14
8152222332775
29
Nguyễn Hoàng Nam
Bùi Văn Lâm
Nguyễn Thị Hồng
Bùi Thị Nhung
Nguyễn Văn Tín
Bùi Ngọc Linh
Nguyễn Văn Khánh
Bùi Thị Trang
1033111206031
Nguyễn Hoài Phương 0
Nguyễn Lan Hương
36
42
Bùi Thanh Bình
43
49
50
Bùi Thị Thu Hà
Nguyễn Quốc Đạt
Picture 5.1
573000.00
0.00
1576000.00
2156000.00
900000.00
570000.00
405000.00
1155000.00
0.00
1947000.00
0.00
1215000.00
800000.00
3456789012315
Question 6:
Write an SQL query to list all menu items whose total sales amount in completed orders in
2023 is below the average total sales amount in 2023 of all menu items, including those with
no sales in 2023. For each menu item, display: ItemID, ItemName, Category, TotalAmount
Zoom
(the total revenue generated from completed orders in 2023 (use 0 for items that were not
sold in 2023). Ensure to calculate the average total sales across all items (including those
with zero revenue). Sort the result by TotalAmount in ascending order, and then by ItemID in
+ 100%
Close
5 of 5
Paper No: 11
