Promotion
CodeGym University
Learning
Course
Tasks
Surveys & Quizzes
Games
Help
Schedule
Community
Users
Forum
Chat
Articles
Success stories
Activity
Reviews
Subscriptions
Light theme
Lessons
Reviews
About us
Start
Start learning
Start learning now
Quest map
Lessons
Module 4. SQL & Hibernate
Level 2
Conditional Functions
Module 4. Working with databases
Level 2,
Lesson 0
List of conditional functions IF() function IFNULL() and NULLIF() functions
CASE statement
Module 4. Working with databases
Level 2,
Lesson 1
CASE statement The second version of the CASE statement Solve the problem using the CASE statement
Grouping data
Module 4. Working with databases
Level 2,
Lesson 2
GROUP BY operator Complex queries with GROUP BY Column names in the result
Grouping by multiple columns
Module 4. Working with databases
Level 2,
Lesson 3
Grouping columns Grouping by calculated columns Grouping by multiple columns
Advanced grouping
Module 4. Working with databases
Level 2,
Lesson 4
HAVING Statement HAVING Usage Example Statement Execution Order
Aggregate functions
Module 4. Working with databases
Level 2,
Lesson 5
List of aggregate functions Analyze employee salaries
Please enable JavaScript to continue using this application.