Question

1. Write a SELECT statement that returns these columns: The count of the number of orders in the Orders table The sum of the TaxAmount columns in the Orders table

Answer 1

Answer:

SELECT

COUNT(SN), SUM(TaxAmount)

FROM ORDERS  

or

SELECT

COUNT(SN) AS NumOrder, SUM(TaxAmount) As TotalTax

FROM ORDERS

Explanation:

Finding it difficult to add my explanation. So, I used an attachment instead

<em />

Download docx