All Posts

Game Play Analysis IV Problem

LeetCode 550. Write an SQL query that reports the fraction...

18 Dec 2020

Game Play Analysis III Problem

LeetCode 534. Write an SQL query that reports for each...

18 Dec 2020

Game Play Analysis II Problem

LeetCode 512. Write a SQL query that reports the device...

18 Dec 2020

Game Play Analysis I Problem

LeetCode 511. Write an SQL query that reports the first...

18 Dec 2020

Employee Bonus Problem

LeetCode 577. Select all employee’s name and bonus whose bonus...

18 Dec 2020

Delete Duplicate Emails Problem

LeetCode 196. Write a SQL query to delete all duplicate...

18 Dec 2020

Daily Leads And Partners Problem

LeetCode 1693. Write an SQL query that will, for each...

18 Dec 2020

Customer Who Visited But Did Not Make Any Transactions Problem

LeetCode 1581. Write an SQL query to find the IDs...

18 Dec 2020

Product's Worth Over Invoices Problem

LeetCode 1677. Write an SQL query that will, for all...

17 Dec 2020

Percentage Of Users Attended A Contest Problem

LeetCode 1633. Write an SQL query to find the percentage...

17 Dec 2020

Fix Names In A Table Problem

LeetCode 1667. Write an SQL query to fix the names...

17 Dec 2020

Duplicate Emails Problem

LeetCode 182. Write a SQL query to find all duplicate...

17 Dec 2020

Customers Who Never Order Problem

LeetCode 183. Write a SQL query to find all customers...

17 Dec 2020

Consecutive Numbers Problem

LeetCode 180. Write an SQL query to find all numbers...

17 Dec 2020

Average Time Of Process Per Machine Problem

LeetCode 1661. There is a factory website that has several...

17 Dec 2020

Second Highest Salary Problem

LeetCode 176. Given the Employee table, write a SQL query...

16 Dec 2020