sqlh3.1

-- Oefening 1

SELECT prod_name
FROM Products;

SELECT prod_name
FROM Products
ORDER BY prod_name;

-- Oefening 2

SELECT prod_id, prod_price, prod_name
FROM Products
ORDER BY prod_price, prod_name;

SELECT prod_id, prod_price, prod_name
FROM Products 
ORDER BY 2, 3;

-- Oefening 3

SELECT prod_id, prod_price, prod_name
FROM Products
ORDER BY prod_price;

SELECT prod_id, prod_price, prod_name
FROM Products
ORDER BY prod_price DESC;