Counting Every Student

How many students does the college have? Return a single row with one column, total_students, holding the number of rows in students. Use COUNT(*) so every row counts, whatever its values hold.

Expected result:

+----------------+
| total_students |
+----------------+
|             30 |
+----------------+
1 row

Hints3 available

Topics:

Aggregates & GROUP BY

Code Editor

Tab to indent (Esc then Tab to move on) · Ctrl+Enter to run · Ctrl+Space to expand shortcuts (sel, ins, desc)

Results

Run your SQL to see every statement's output here, then how it compares with the expected answer.

Not sure what is in a table? SHOW TABLES lists them and DESCRIBE students shows the columns — or open the database browser on the left.