Series
A collection of leetcode solustion
607. Sales Person 題目敘述 SQL Schema > Create table If Not Exists SalesPerson (sales_id int, name varchar(255), salary int, commission_rate int, hire_date date) Create table If Not Exists Company (com_id int, name varchar(255), city varchar(255)...
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...