/*
 *  project2.sql
 * 
 *  author: C. Painter-Wakefield (please replace with your name)
 *
 */

/* This next query lists all of the houses and related info. */
SELECT * FROM hogwarts_houses;

/* This query returns a count of all the hogwarts students we have records */
/* of; here we are using an aggregate function (COUNT), which we will look */
/* at in a future lecture.                                                 */
SELECT COUNT(*) FROM hogwarts_students;

/* Please delete the queries above and replace with your answers for       */
/* project2!                                                               */

-- Note you can also do single-line comments this way
