Body Count

Challenge:

How many users exist in the Shallow Grave University database? Submit the flag in the following format: flag{#}

Use the file from Address Book.
Max attempts: 10

Solution:

Using the database I had created in the Address Book challenge I reviewed the database tables to refresh my memory:

mysql> SHOW TABLES;
+---------------------+
| Tables_in_westridge |
+---------------------+
| countries           |
| courses             |
| degree_types        |
| enrollments         |
| passwords           |
| payment_statuses    |
| programs            |
| roles               |
| roles_assigned      |
| states              |
| term_courses        |
| terms               |
| users               |
+---------------------+

The challenge description is asking for a count of users, and there is a table named "users", making the SQL query pretty straightforward:

mysql> SELECT COUNT(*) FROM users;
+----------+
| COUNT(*) |
+----------+
|      900 |
+----------+

The compete flag is flag{900}.