【SQL】刷题整理[三]

一、力扣175. 组合两个表

代码如下：

select FirstName,LastName,City,State 
from Person left join Address
on Person.PersonId=Address.PersonId; 

二、力扣1050. 合作过至少三次的演员和导演

代码如下：

select actor_id,director_id
from ActorDirector
group by actor_id,director_id
having count(actor_id)>=3 and count(director_id)>=3;

三、力扣1873. 计算特殊奖金

代码如下：

select employee_id,
        (case when mod(employee_id,2)!=0
         and name not like 'M%' then salary else 0 end) as bonus
from Employees;

四、力扣1890. 2020年最后一次登录

代码如下：

select user_id ,max(time_stamp) as last_stamp
from Logins
where year(time_stamp) = '2020'
group by user_id;

五、力扣1777. 每家商店的产品价格

代码如下：

select product_id
    ,max(case when store = 'store1' then price else null end) store1 
    ,max(case when store = 'store2' then price else null end) store2 
    ,max(case when store = 'store3' then price else null end) store3
from Products
group by product_id;

✨✨✨✨
🤣🤣🤣🤣
旺财加油，把题刷光光