题解 | #高级操作符练习(1)#
高级操作符练习(1)
http://www.nowcoder.com/practice/2d2e37474197488fbdf8f9206f66651c
select
device_id,
gender,
age,
university,
gpa
from user_profile
WHERE
gpa>3.5
and
gender='male'
考点 where and 连接条件
gpa要大于3.5(gpa>3.5)
and
gender要等男性(gender='male')