- TotalRevenue - the total revenue (sum of Quantity Price) from all completed orders in that
month
For example, when we execute the MonthlySalesSummary procedure by using the following
query, the results must be shown as in the following figure:
execute MonthlySalesSummary 2023
7 of 7
Paper No: 11
Zoom
Month
NumberOfOrders
1
1/2023 1
2
2/2023 0
0.00
3
3/2023 4
TotalRevenue
475000.00
3315000.00
4
4/2023 2
1390000.00
5
5/2023 1
575000.00
6
6/2023 4
2115000.00
7
7/2023 1
1105000.00
8/2023
1
1070000.00
+ 100%
Close
