Write SQL filtering, grouping, CASE, UNION tasks

Use the provided orders rows for all results below. a) Paid orders on 2025-09-01 with amount >= 10 Result: b) Total paid amount per user, rounded down with FLOOR(SUM(amount)) Result: FLOOR(SUM(amount)) first sums the full decimal amounts, then removes the fractional part from the total. SUM(FLOOR(amount)) would remove the fractional part from every individual order before summing, so fractional cents can be lost separately and may not accumulate into a whole dollar…