Microsoft SQL 2022
SQL Server 2022 new features
SELECT customer_name, SUM(order_amount) AS total_order_amount FROM dbdocs_orders GROUP BY customer_name ORDER BY total_order_amount DESC;
dbdocs_orders
SELECT product_name, SUM(sales_amount) AS total_sales FROM dbdocs_sales WHERE sales_date BETWEEN '2023-01-01' AND '2023-06-30' GROUP BY product_name ORDER BY total_sales DESC;