SQL Concepts Quiz for Grade 12 Students

Describe the output of the following SQL query:
SELECT CustomerID, SUM(SalesAmount) AS TotalSales

FROM Orders

GROUP BY CustomerID;

Describe the output of the following SQL query:
SELECT ProductName, Price

FROM Products

ORDER BY Price DESC;

Describe the output of the following SQL query:
SELECT DepartmentID, AVG(Salary) AS AvgSalary

FROM Employees

GROUP BY DepartmentID

HAVING AVG(Salary) > 50000;

Describe the output of the following SQL query:
SELECT CustomerName

FROM Customers

WHERE CustomerName LIKE 'J%';

Describe the output of the following SQL query:
SELECT EmployeeName

FROM Employees

WHERE Department = 'Sales' OR Department = 'Marketing';

Describe the output of the following SQL query:
SELECT ProductName, Price

FROM Products

WHERE Price > 100 AND Price < 500;

Describe the output of the following SQL query:
SELECT *

FROM Orders

WHERE MONTH(OrderDate) = 6;

Describe the output of the following SQL query:
SELECT DepartmentID, COUNT(*) AS EmployeeCount

FROM Employees

GROUP BY DepartmentID;

Describe the output of the following SQL query:
SELECT ProductID, SUM(SalesAmount) AS TotalRevenue

FROM OrderDetails

GROUP BY ProductID;

Describe the output of the following SQL query:
SELECT CategoryID, AVG(Price) AS AvgPrice

FROM Products

GROUP BY CategoryID;