Question 1 of 30
A retail company is analyzing its sales data stored in a relational database. The database contains a table named `Sales` with the following columns: `SaleID`, `ProductID`, `Quantity`, `Price`, and `SaleDate`. The company wants to calculate the total revenue generated from sales of a specific product (ProductID = 101) during the month of March 2023. Which SQL query would correctly retrieve this information?
`SELECT SUM(Quantity * Price) AS TotalRevenue FROM Sales WHERE ProductID = 101 AND SaleDate BETWEEN '2023-03-01' AND '2023-03-31';`
`SELECT COUNT(SaleID) AS TotalSales FROM Sales WHERE ProductID = 101 AND SaleDate >= '2023-03-01' AND SaleDate <= '2023-03-31';`
`SELECT AVG(Price) AS AveragePrice FROM Sales WHERE ProductID = 101 AND SaleDate >= '2023-03-01' AND SaleDate <= '2023-03-31';`
`SELECT SUM(Quantity) AS TotalQuantity FROM Sales WHERE ProductID = 101 AND SaleDate > '2023-03-01' AND SaleDate < '2023-03-31';`

Preparing for Microsoft 98-364 Database Fundamentals? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free