Greenshades Software interview question

Simple SQL Queries given the schema for a few tables