sql-easy

Visit the website

This repository contains all solutions of sql-easy

No	Name	Completion Date	Solution
1	Lesson 1: SELECT *	2024/05/14	Click here
2	Lesson 2: SELECT specific columns	2024/05/15	Click here
3	Lesson 3: WHERE ... Equals	2025/05/16	Click here
4	Lesson 4: WHERE ... Greater than	2024/05/17	Click here
5	Lesson 5: WHERE ... Greater than or equal	2024/05/20	Click here
6	Lesson 6: AND	2024/05/21	Click here
7	Lesson 7: OR	2024/05/22	Click here
8	Lesson 8: IN	2024/05/27	Click here
9	Lesson 9: DISTINCT	2024/05/28	Click here
10	Lesson 10: ORDER BY	2024/05/29	Click here
11	Lesson 11: LIMIT # of returned rows	2024/05/30	Click here
12	Lesson 12: COUNT(*)	2024/05/31	Click here
13	Lesson 13: COUNT(*) ... WHERE	2024/06/03	Click here
14	Lesson 14: SUM	2024/06/04	Click here
15	Lesson 15: AVG	2024/06/05	Click here
16	Lesson 16: MAX and MIN	2024/06/06	Click here
17	Lesson 17: GROUP BY	2024/06/07	Click here
18	Lesson 18: Nested queries	2024/06/10	Click here
19	Lesson 19: NULL	2024/06/11	Click here
20	Lesson 20: Date	2024/06/12	Click here
21	Lesson 21: Inner joins	2024/06/13	Click here
22	Lesson 22: Multiple joins	2024/06/14	Click here
23	Lesson 23: Joins with WHERE	2024/06/19	Click here
24	Lesson 24: Left joins	2024/06/20	Click here
25	Lesson 25: Table alias	2024/06/21	Click here
26	Lesson 26: Column alias	2024/06/24	Click here
27	Lesson 27: Self joins	2024/06/25	Click here
28	Lesson 28: LIKE	2024/06/26	Click here
29	Lesson 29: CASE	2024/06/27	Click here
30	Lesson 30: SUBSTR	2024/06/28	Click here
31	Lesson 31: COALESCE	2024/07/01	Click here