MYSQL练习003

博客仅作为记录，有误部分请在评论区指正，谢谢！！

👨‍💻作者:东隅桑
💕:东隅已逝,桑榆非晚。

题目九

解答九

select
  devie_id,
  gender,
  age,
  university
from
  user_profile
where
  university != "复旦大学";
#或university <> "复旦大学";
#或not university = "复旦大学";
#或university not in "复旦大学";
#或university not like "复旦大学";

---

---

题目十

解答十

select
  device_id,
  gender,
  age,
  university
from
  user_profile
where
  age is not null;

---

---

题目十一

解答十一

select
  device_id,
  gender,
  age,
  university,
  gpa
from
  user_profile
where
  gender = 'male' and gpa >3.5;

---

---

题目十二

解答十二

select
  device_id,
  gender,
  age,
  university,
  gpa
from 
  user_profile
where
 university = '北京大学' or gpa > 3.7;