【SQL】刷题整理[八]

一、力扣580. 统计各专业学生人数

代码如下：

select dept_name,count(student_id) as student_number
from department 
    left outer join 
    student 
    on student.dept_id = department.dept_id
group by dept_name
order by student_number desc,dept_name;

二、力扣1683. 无效推文

代码如下：

select tweet_id
from Tweets
where length(content)>15;

三、力扣620. 有趣的电影

代码如下：

select *
from cinema
where description <> 'boring' and id%2 <>0
order by rating desc;

🤦‍♀️🤦‍♀️🤦‍♀️
旺财得再加把劲！！！