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