SQL Section $3$: Run Simple Queries

Construct three queries with the following components at a minimum:

Query $1.$ SELECT from a single table with a WHERE clause, producing a derived attribute.

Query $2.$ A NATURAL, INNER, or OUTER JOIN between two of your tables.

Query $3.$ A query covering one or more tables that uses a GROUP BY statement on at least one of your variables. INTERNAL MODEL