MYSQ练习002

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

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

题目五

解答五

select
  device_id as user_infos_example
from
  user_profile
limit
  0,2;

---

---

题目六

解答六

select
  device_id,
  university
from
  user_profile
where
  university = "北京大学";

---

---

题目七

解答七

select
  device_id,
  gender,
  age,
  university
from
  user_profile
where
  age > 24;

---

---

题目八

解答八

#方法一
#between and 取闭区间
select
  device_id,
  gender,
  age
from 
  user_profile
where
  between 20 ang 23;
#------------------------------分割线-------------------------------
#方法二
select
  device_id,
  gender,
  age
from 
  user_profile
where
  age >= 20 and age <= 23;