Question paper (build 07.05.20.19)
- NumberOfOrders - the total count of completed orders in that month
- TotalRevenue - the total revenue (sum of Quantity * Price) from all completed orders in that
month
For example, when we execute the MonthlySales Summary procedure by using the following
query, the results must be shown as in the following figure:
execute MonthlySalesSummary 2023
7 of 7
Paper No: 10
Month
12
1/2023
1
NumberOfOrders Total Revenue
475000.00
2
2/2023 0
0.00
3
3/2023 4
3315000.00
4
4/2023 2
1390000.00
5
5/2023 1
575000.00
6
6/2023 4
2115000.00
10000
