SQL Where,GB,Having,OB Part 3

What does the following SQL query do?

• Shows all shipped orders sorted by the date they were placed.

• Shows all orders sorted by status.

• Shows all orders, including canceled ones.

What does the following SQL query do?

• Show all products with prices under $20.

• Show products with an average price of $20 or more.

• Show products with an average price below $20.

Which SQL statement will return all orders placed by customers from "New York"?

• SELECT * FROM Orders ORDER BY City;

• SELECT * FROM Orders WHERE City = 'New York';

• SELECT * FROM Orders HAVING City = 'New York';

What will the following SQL query return?

• Departments with 3 or more employees.

• All employees sorted by department.

• Departments with fewer than 3 employees.

If you want to group students by their grades and find out how many students are in each grade, which clause do you need?

• WHERE

• HAVING

• ORDER BY

• GROUP BY

How can you find the maximum price of items in a store?

• SELECT MAX(Price) FROM Items;

• SELECT * FROM Items ORDER BY Price;

• SELECT Price FROM Items WHERE MAX(Price);

If you want to see all customers who made purchases in 2024, which SQL statement would you use?

• SELECT * FROM Customers WHERE PurchaseYear = 2024;

• SELECT * FROM Customers WHERE YEAR(PurchaseDate) = 2024;

• SELECT * FROM Customers ORDER BY PurchaseDate;

How would you sort a list of students by their last names in alphabetical order?

• SELECT * FROM Students ORDER BY LastName ASC;

• SELECT * FROM Students GROUP BY LastName;

• SELECT * FROM Students ORDER BY FirstName DESC;