Not a programmer 不工程的攻城獅

Not a programmer 不工程的攻城獅

Follow

Series

LeetCode Solution

A collection of leetcode solustion

Articles in this series

LeetCode Solution, Medium, 607. Sales Person

607. Sales Person 題目敘述 SQL Schema > Create table If Not Exists SalesPerson (sales_id int, name varchar(255), salary int, commission_rate int,...

LeetCode Solution, Medium, 607. Sales Person

LeetCode Solution, Easy, 1158. Market Analysis I

1158. Market Analysis I 題目敘述 SQL Schema > Create table If Not Exists Users (user_id int, join_date date, favorite_brand varchar(10)) Create...

LeetCode Solution, Easy, 1158. Market Analysis I

LeetCode Solution, Easy, 1050. Actors and Directors Who Cooperated At Least Three Times

1050. Actors and Directors Who Cooperated At Least Three Times 題目敘述 SQL Schema > Create table If Not Exists ActorDirector (actor_id int,...

LeetCode Solution, Easy, 1050. Actors and Directors Who Cooperated At Least Three Times

LeetCode Solution, Easy, 182. Duplicate Emails

182. Duplicate Emails 題目敘述 SQL Schema > Create table If Not Exists Person (id int, email varchar(255)) Truncate table Person insert into...

LeetCode Solution, Easy, 182. Duplicate Emails

LeetCode Solution, Easy, 511. Game Play Analysis I

511. Game Play Analysis I 題目敘述 SQL Schema: Create table If Not Exists Activity (player_id int, device_id int, event_date date, games_played...

LeetCode Solution, Easy, 511. Game Play Analysis I

LeetCode Solution, Easy, 1729. Find Followers Count

1729. Find Followers Count 題目敘述 SQL Schema > Create table If Not Exists Followers(user_id int, follower_id int) Truncate table Followers insert into...

LeetCode Solution, Easy, 1729. Find Followers Count