Database: AdventureWorksDW Database: Database: AdventureWorksDW

Tables: Fact call center

Schema: dbo

Need: Build and test the SQL to answer this question in a SINGLE SQL

statement: Using data for the $\text{'}$AM$\text{'}$ shift, please produce a list showing the

number of issues raised

Retrieve only those

DO NOT sort the data unless explicitl $2500$ orders for that

wage type $($DO NOT

Use the result of your SQL to answer the following

The number of rows retrieved is

words!$)$

$($do not write in

the screen follo

Tables: Fact call center

Schema: dbo

Need: Build and test the SQL to answer this question in a single SQL statement. Using data for the $\text{'}$AM$\text{'}$ shift, please produce a list showing the number of issues raised and the number of orders processed by wage type. Retreive only those rows that generated more than $2500$ orders for that wage type $($do not sort the date unless explicitly asked to$.)$

what was the number of rows retrieved?

what was the number of issues raised $($shown$)$ in the first row?