All Posts

MySQL SELECT Statement

The SELECT statement allows us to read data from one...

30 Dec 2020

MySQL Tutorial List

A growing list of MySQL tutorials.

30 Dec 2020

Total Sales Amount By Year Problem

LeetCode 1384. Write an SQL query to report the Total...

29 Dec 2020

Sales By Day Of The Week Problem

LeetCode 1479. Write an SQL query to report how many...

29 Dec 2020

Hopper Company Queries III Problem

LeetCode 1651. Write an SQL query to compute the average_ride_distance...

29 Dec 2020

Get The Second Most Recent Activity Problem

LeetCode 1369. Write an SQL query to show the second...

29 Dec 2020

Find The Quiet Students In All Exams Problem

LeetCode 1412. Write an SQL query to report the students...

29 Dec 2020

Tournament Winners Problem

LeetCode 1194. Write an SQL query to find the winner...

28 Dec 2020

Students Report By Geography Problem

LeetCode 618. A U.S graduate school has students from Asia,...

28 Dec 2020

Report Contiguous Dates Problem

LeetCode 1225. Write an SQL query to generate a report...

28 Dec 2020

Median Employee Salary Problem

LeetCode 569. Write a SQL query to find the median...

28 Dec 2020

Market Analysis II Problem

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

28 Dec 2020

Hopper Company Queries I Problem

LeetCode 1635. Write an SQL query to report the following...

28 Dec 2020

Game Play Analysis V Problem

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

28 Dec 2020

User Purchase Platform Problem

LeetCode 1127. Write an SQL query to find the total...

27 Dec 2020

Trips And Users Problem

LeetCode 262. Write a SQL query to find the cancellation...

27 Dec 2020