All Posts

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

Employees Earning More Than Their Managers Problem

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

16 Dec 2020

Bank Account Summary II Problem

LeetCode 1587. Write an SQL query to report the name...

16 Dec 2020

Group Sold Products By The Date Problem

LeetCode 1484. Write an SQL query to find for each...

15 Dec 2020

All Valid Triplets That Can Represent A Country Problem

LeetCode 1623. Write an SQL query to find all the...

15 Dec 2020

Warehouse Manager Problem

LeetCode 1571. Write an SQL query to report how much...

13 Dec 2020