Write four “select” queries

In a single file named , write four “select” queries that meet the following criteria:

1. Select unique game dates, sorted by date.
2. Select offense and defense teams from games on Thanksgiving day of 2015 (Nov 26), in which a touchdown occurred (by the team on offense); do not sort the results.
3. Select the first 10 descriptions in which a fumble occurred.
4. Select unique pairs of penalty type and penalty yards for penalty types that are not blank, and order by penalty yards so that the greatest penalty yards is first.

The exact desired output can be discovered by running the test program (see below). Your SQL queries must produce the desired output to earn full credit.