Customer query

Write a filtered and ordered query on the customer table.

Challenge 1: Write a query

In this challenge you will write a query combining SELECT, WHERE and ORDER BY. Few hints; use what you learned.

SELECT name, price FROM products WHERE price > 10 ORDER BY price DESC;

This query sorts products over 10 by price descending.

name, price is selected from products. WHERE keeps only the rows where price > 10 holds. The result is sorted by price in descending order.

Select name and price from products where price > 10, ordered by price descending.

Show example solution

SELECT name, price
FROM products
WHERE price > 10
ORDER BY price DESC

Next lesson: Order report