Learn Standard SQL Functions | Interactive Course | Vertabelo Academy

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Well done. Now you know how to handle conditional computations in SQL.

But that's not the end. We also prepared a special quiz for you to check how much you have learned. Click Next Exercise to start the quiz.

29/29 Congratulations

1. Introduction

2. Table candidate

3. Table application

4. Simple CASE WHEN

5. Simple CASE WHEN continued

6. Simple CASE WHEN with NULLs

7. Simple CASE WHEN – practice

8. Searched CASE WHEN

9. Searched CASE WHEN with various conditions

10. Searched CASE WHEN with NULLs

11. Searched CASE WHEN with NULLs – continued

12. Searched CASE WHEN – additional practice

13. CASE WHEN with SUM

14. Counting rows with CASE WHEN and SUM

15. CASE WHEN with SUM continued

16. CASE WHEN with COUNT

17. CASE WHEN with COUNT – practice

18. CASE WHEN with COUNT DISTINCT

19. CASE WHEN with GROUP BY

20. CASE WHEN with GROUP BY – practice

21. CASE WHEN with GROUP BY – practice 2

22. Another use of CASE WHEN with GROUP BY

23. CASE WHEN in GROUP BY

29. Congratulations

Wow, amazing! You are really awesome at this!

That's all for today, congratulations. Visit us again when you're ready for Part 8.

Click Next exercise to finish this part.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.