Reference no: EM132212309

Write queries based on the following requirements using Premier Database.

Premier Database Is Already Installed on the SQL Server you used at class.

For each question, you are required to submit SQL query code and a screen shot of your query results (If your results contains more than 15 records, you can submit a screen shot of the top 15 records).

Use the employee ID and the full name of the employee who sold or packaged the transactions placed by customer Benjamin Jones.

Each employee should only show up once In your results.

Use the date of the first transaction handled by each employee (represented by employee ID). Show your results In ascending order on employee ID.

Use the number of transactions handled by each department.

Only in dude the departments who handled transactions. Show your results in descending order on department.

Use all the full names of the employees who sold item 000078. Show your results in ascending order on employee's last name.

Use the following information for each transaction: item codes, the full name and mailing address of the member who placed the transaction.

Use the total number of items (sum of quantity of each item) sold to members living in Indiana, Illinois, and Kentucky. (List your results separately for each state.)

List the total number of transactions made by members in each state. Show your results in descending order on state abbreviations.

List the each employee's full name and the transaction ID and transaction date he/she handled, include those who haven't handled any transactions.

Use the number of transactions handled by each department. Include departments that have not handled any transactions

Show your results in ascending order on department. Use the transactions by members with first name starts with "B", including members who have not purchased any items.

Show the full name of each member in the ascending order on member's last name.

List the transaction ID and total item quantity made Online.

List the phone number of the members whose transactions were handled by employee with Associate in the job title.

List the departments that handled less than 5 transactions.

List the total number of transactions made by female and male members.

List the state from which female members have placed more than 20 transactions Show those states abbreviate and number of transactions.

Rank your results from the highest to the lowest on total number of transactions.