Exercise: Top 3 Courses
Get first 3 unique courses alphabetically.
Solution
sql
1SELECT DISTINCT course FROM students
2ORDER BY course
3LIMIT 3;
Get first 3 unique courses alphabetically.
1SELECT DISTINCT course FROM students
2ORDER BY course
3LIMIT 3;