🙏 We need your help! SQLtest.online has no ads and lives only on donations. Even a small amount helps. Donate now →
SQL code copied to buffer
Task 40:

Orders Total

SQL Server 2022
Calculate the sales totals for orders placed in June 2008. Use the SalesOrderHeader table.
Output columns:
OrdersCount - the number of orders;
AmountTotal - the total amount due (TotalDue);
TaxTotal - the total tax (TaxAmt).
Expected result Columns: 3 · Rows: 1
OrdersCount AmountTotal TaxTotal

Write your query below and click "Check it!". Tables are described in the right pane.

By checking a query, you agree that it is stored without your account details and may be included in anonymized datasets, including for AI training. Learn more

The query result will appear here. Ctrl+Enter - Run query