Question
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
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 employees 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 employees full name and the transaction ID and transaction date he/she handled, include those who havent 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 members 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.
database:https://onedrive.live.com/redir?resid=A1E5259BDD065B48!4478&authkey=!AH3fj0xU0Jv_Jyc&ithint=file%2caccdb
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started