Reference no: EM131267228
Please write queries based on the following requirements using Premier Database. Premier Database can be downloaded from Blackboard. You are required to submit SQL query code. You do NOT need to submit your query results. However, it is strongly recommended that you test your queries in Premier Database to make sure your query is accurate.
1. List the employee ID and the full name of the employee who sole or packaged the transactions placed by customer Benjamin Jones. Each employee should only show up once in your results.
2. List the date of the first transaction handled by each employee (represented by employee ID). Show your results in ascending order on employee ID.
3. List the number of transactions handled by each department. Only include the departments who handled transactions. Show your results in descending order on department.
4. List all the full names of the employees who sold item 000078. Show your results in ascending order on employee's last name.
5. List the following information for each transaction: item codes, the full name and mailing address of the member who placed the transaction.
6. List the total number of items sold to members who live in Indiana, Illinois, and Kentucky.
7. List the total number of transactions made by members in each state. Show your results in descending order on state abbreviations.
8. 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.
9. List the number of transactions handled by each department. Include departments that have not handled any transactions. Show your results in ascending order on department.
10. List 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.
11. List the transaction ID and total item quantity made Online.
12. List the phone number of the members whose transactions were handled by employee with Associate in the job title.
13. List the department that handled less than 5 transactions.
14. List the total number of transactions made by female and male members.
15. List the state from which female members have placed more than 20 transactions. Show those state abbreviate and number of transactions. Rank your results from the highest to the lowest on total number of transactions.
Attachment:- Premier.rar