Hello guys,
can you help me distinct count ourder_number and sum order_quantity and filled_quantity.
order_number Commodity date ordered_quantity
2749316 FROZEN 11/5/2022 2
2749316 PERISHABLES 11/5/2022 4
2749316 GROCERY 11/5/2022 1
5087400 FROZEN 11/5/2022 4
5087400 PERISHABLES 11/5/2022 16
5087400 GROCERY 1 1/5/2022 4
I want this result.
order_number_Count Commodity ordered_quantity
2 FROZEN 6
PERISHABLES 20
GROCERY 5
row() number or rank () or dense_rank() can be used I am not sure.
Thanks,