Review the data in the provided database and design the queries to do the following. Your queries should be named Query$1,$ Query$2,...,$ and Query$6,$ respectively,

List each product that has been sold in Edmonton and the total quantity of that product that has been sold in Edmonton.

Allow the user to enter the name $($first and last name$)$ of an employee and list the name $($first and last name$)$ and birth date of all employees who are older than the person entered.

Create a list of employees $($FirstName$,$ LastName$)$ and the store that they work at $($StoreName$).$ Stores with no employees must be included in the result. Employees not attached to a store must also be included. For example, your result would look similar to the table below. Wayne Shelton is not are not shown below. are not shown below.

$\backslash$table$[[$FirstName$,$LastName,storeName$],[$Wayne$,$Shelton,$],[$Edwin$,$Nelson,Number $12],[$Brooks$,$Downey,Dunn's Market$],[,,$Bridgewater$]]$

List each store name, the province it is in$,$ and the number of stores that are in that province. For example, your result would look like:

$\backslash$table$[[$storeName$,$province,Number of Stores in the province$],[$Borden North,ON$,1],[$Calgary$,$AB$,3],[$Dunn$\text{'}$s Market,SK$,2]]$

Allow the user to enter the name $($first and last names$)$ of an employee and list the name $($first and last names$)$ of all employees who have the same supervisor as the employee entered. The employee entered must be excluded from the list. For example, if you enter Madison McGrath, the following result would be displayed

$\backslash$table$[[$FirstName$,$LastName$],[$Vanessa$,$Terry$],[$Victor$,$Navarro$]]$

Given the following query design, provide the corresponding SQL statement for the query. Note that this query is based on a datobase $($not provided$)$ different from the one orovided with thic int

or:

$1$

M

Glven the following query design, provide the corresponding SQL statement for the query. Note that this query is based on a database $($not provided$)$ different from the one provided with this lab.

Glven the following query design, provide the corresponding SQL statement for the query. Note that this query is based on a databose $($not provided$)$ different from the one provided with this inh

$\backslash$table$[[$Field:$,$id$,,,.,],[$Table$,$ALAhon,$\backslash$table$[[$FirstWane$],[$Austhors$]],$subject,tutleid,$],[$Totat$,$Group Ey$,\backslash$table$[[$Authors$],[$Group By$]],$Avithors,BookAuthors,$],[\backslash$table$[[$Sort$],[$Showr$]],$Ascending,,Where,Count,$],[\backslash$table$[[$Showe$],[$Criteria:$]],,,,,],[$or$,,,$Action',,$$