This is a homework assignment for a database class. A schema that uses these queries is  unavailable, but this assignment demonstrates advanced sql skills.