Exercise: Count Students
Count the number of students in grade A.
Solution
sql
1SELECT COUNT(*) FROM students
2WHERE grade = 'A';Practice
sql
1-- Count JavaScript students
2SELECT COUNT(*) FROM students
3WHERE course = 'JavaScript';
Count the number of students in grade A.
1SELECT COUNT(*) FROM students
2WHERE grade = 'A';1-- Count JavaScript students
2SELECT COUNT(*) FROM students
3WHERE course = 'JavaScript';