Lesson list for Level 2 of CodeGym's SQL & Hibernate quest

Conditional Functions
SQL & Hibernate
Level 2, Lesson 0
List of conditional functions IF() function IFNULL() and NULLIF() functions
Available
CASE statement
SQL & Hibernate
Level 2, Lesson 1
CASE statement The second version of the CASE statement Solve the problem using the CASE statement
Available
Grouping data
SQL & Hibernate
Level 2, Lesson 2
GROUP BY operator Complex queries with GROUP BY Column names in the result
Available
Grouping by multiple columns
SQL & Hibernate
Level 2, Lesson 3
Grouping columns Grouping by calculated columns Grouping by multiple columns
Available
Advanced grouping
SQL & Hibernate
Level 2, Lesson 4
HAVING Statement HAVING Usage Example Statement Execution Order
Available
Aggregate functions
SQL & Hibernate
Level 2, Lesson 5
List of aggregate functions Analyze employee salaries
Available