Learn Standard SQL Functions | Interactive Course | Vertabelo Academy

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

27/29 Exercise 3

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

Fine! How about the third one?

Show each degree course name and a second column called popularity. If at least 5 distinct candidates applied, show 'high', otherwise show 'low'.

Use DISTINCT candidate_id for the COUNT() function.

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.