请推荐一下合成生物学的资料 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Biology - 生物学

请推荐一下合成生物学的资料

请推荐一下合成生物学的资料# Biology - 生物学

h*n2017-05-08 07:05

1 楼

table Orders:
primary key order_id, foreign key customer_id
table Customers:
primary key customer_id, name, address
find out if there's any customer not having any order.
single query, and no nested query allowed.

b*72017-05-08 07:05

2 楼

本人生物小白。。。
想了解一下合成生物学的研究进展，和产业化前景。请大家推荐点读物，或者渠道。谢
谢谢谢

b*u2017-05-08 07:05

3 楼

select
count*)
from
customers as c
left join orders as o on (c.customerid = o.customerid)
where
o.customerid is null

s*e2017-05-08 07:05

4 楼

select customer_id
from Customers
minus
select distinct customer_id
from Orders
order by customer_id;

【在 h*********n 的大作中提到】

: table Orders:
: primary key order_id, foreign key customer_id
: table Customers:
: primary key customer_id, name, address
: find out if there's any customer not having any order.
: single query, and no nested query allowed.

h*n2017-05-08 07:05

5 楼

您这个还是两次查询啊。

【在 s**********e 的大作中提到】

: select customer_id
: from Customers
: minus
: select distinct customer_id
: from Orders
: order by customer_id;

h*n2017-05-08 07:05

6 楼

这个可以。
再来一个：学生编号，课程，成绩。判断是否有一个学生所有成绩没有F也没有A。每个
学生选的课可能不同。
Records: Id, Course, Grade

【在 b******u 的大作中提到】

: select
: count*)
: from
: customers as c
: left join orders as o on (c.customerid = o.customerid)
: where
: o.customerid is null

z*h2017-05-08 07:05

7 楼

select distinct id from records where grade <> 'f' and grade <>'a'

h*n2017-05-08 07:05

8 楼

这个是至少一门在B和D之间的所有学生。
找的是至少一个学生，所有成绩在B到D之间。

【在 z****h 的大作中提到】

: select distinct id from records where grade <> 'f' and grade <>'a'

z*h2017-05-08 07:05

9 楼

select distinct id from records where grade between 'b' and 'd'

b*u2017-05-08 07:05

10 楼

select
studentid
from
Grade
group by
studentid
having
(
max(case when grade = 'A' then 1 else 0 end ) = 0 and
max(case when grade = 'F' then 1 else 0 end ) = 0
)

z*h2017-05-08 07:05

11 楼

select distinct id from records where id not in (select distinct id from
records where grade = 'a' or grade = 'f')