Please write queries based on the following requirements using Premier Database.

Question

Please 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 1) SQL query code and 2) a screen shot of your query results (if your results contains more than 15 records, you can submit a screen shot of the top IS records). 3. list the number of transactions handled by each department. Only include the departments who handed transactions Show your results in descending order on department

Explanation / Answer

As database is not provided.

Assume in the database , there are two tables : Department and transactions where deptName is common column between them.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---