For this assignment, you will submit one file containing thirteen SQL statements. Each SQL statement is worth $1$ grade point. The format for the filename is as follows.

Copy and paste question with its number and paste just above each query in your SQL file. Leave a blank line between each query so that I can easily distinguish them separately.

File Edit View Query Project Tools Window HelpWhen you execute your queries, if the number of rows returned does not match the number of rows in the instructions, then you know to go back and modify your queries.

Sales Orders Database

$$Show me all the information on our employees.$(8$ rows$)$

$$Show me a list of cities, in alphabetical order, where our vendors are located, and include the names of the vendors we work with in each city.$(10$ rows$)$

Entertainment Agency Database

$$Give me the names and phone numbers of all our agents, and list them in last name$/$first name order.$(9$ rows$)$

$$Give me the information on all our engagements.$(111$ rows$)$

$$List all engagements and their associated start dates. Sort the records by date in descending order and by engagement in ascending order.$(111$ rows$)$

School Scheduling Database

$$Show me a complete list of all the subjects we offer.$(56$ rows$)$

$$What kinds of titles are associated with our faculty?$(3$ rows$)$

$$List the names and phone numbers of all our staff, and sort them by last name and first name.$(27$ rows$)$

Bowling League Database

$$List all of the teams in alphabetical order.$(10$ rows$)$

$$Show me all the bowling score information for each of our members.$(1344$ rows$)$

$$Show me a list of bowlers and their addresses, and sort it in alphabetical order.$(32$ rows$)$

Recipes Database

$$Show me a list of all the ingredients we currently keep track of$.(79$ rows$)$

$$Show me all the main recipe information, and sort it by the name of the recipe in alphabetical order.$(15$ rows$)$