1158. Market Analysis I 題目敘述 SQL Schema > Create table If Not Exists Users (user_id int, join_date date, favorite_brand varchar(10)) Create table If Not Exists Orders (order_id int, order_date date, item_id int, buyer_id int, seller_id int) ...
1050. Actors and Directors Who Cooperated At Least Three Times 題目敘述 SQL Schema > Create table If Not Exists ActorDirector (actor_id int, director_id int, timestamp int) Truncate table ActorDirector insert into ActorDirector (actor_id, dir...
182. Duplicate Emails 題目敘述 SQL Schema > Create table If Not Exists Person (id int, email varchar(255)) Truncate table Person insert into Person (id, email) values ('1', 'a@b.com') insert into Person (id, email) values ('2', 'c@d.com')...
511. Game Play Analysis I 題目敘述 SQL Schema: Create table If Not Exists Activity (player_id int, device_id int, event_date date, games_played int) Truncate table Activity insert into Activity (player_id, device_id, event_date, games_played) values ('1'...
1729. Find Followers Count 題目敘述 SQL Schema > Create table If Not Exists Followers(user_id int, follower_id int) Truncate table Followers insert into Followers (user_id, follower_id) values ('0', '1') insert into Followers (user_id, follower_id) value...
1693. Daily Leads and Partners 題目敘述 SQL Schema > Create table If Not Exists DailySales(date_id date, make_name varchar(20), lead_id int, partner_id int) Truncate table DailySales insert into DailySales (date_id, make_name, lead_id, partner_id) values...