Using SQL to Query the Big E$$s Electric Database

Your computer internship at a local electronics store, Big E$\text{'}$s Electric, is coming to an end, and management is considering offering you a full$-$time position with the company. For this position, management is not only looking for someone who is familiar with Access but also someone who is able to write SQL$.$ You have been asked to create some queries in their sales database using only SQL$.$ Additionally, you will create a crosstab query that will help view quarterly data by employee.

h$.$ Create a SQL query based on tblTransactionDetails that will display the ProductID of those products whose total sales volume has exceeded $140.$ Name the totaled Quantity field TotalSalesVolume, and then group by ProductID. Save your query as qryHighVolumeProducts$\_$initialLastname.

i$.$ Create a SQL query based on tblProducts and tblTransactionDetails that will display all the fields from tblProducts and the TransactionID and Quantity fields from tblTransactionDetails. Use a join to include all products, regardless of whether or not they have been purchased. Sort in ascending order by Brand. Save your query as qryTransactionDetails$\_$initialLastname.

j$.$ Create a SQL query based on tblTransaction and tblEmployees that will display all the fields from tblTransaction and the FirstName and LastName fields from tblEmployees. Use a join to include all employees, regardless if they have sold any products. Sort in ascending order by the employee$$s first name and last name. Save your query as qryEmpTransaction$\_$initialLastname, and then close the query.

k$.($Optional$)$ Create a SQL subquery that will list the total sales volume for products sold in the first quarter of $2020.$ Name the totaled Quantity field Quarter$1$Volume. Save the query as qryQtr$1$Sales$\_$initialLastname.