CREATE TABLE product (id INTEGER, name TEXT, price REAL);
INSERT INTO product VALUES (1, 'Lamp', 20.0), (2, 'Pen', 1.5), (3, 'Mug', 8.0);
-- ORDER BY sorts ascending unless told otherwise
SELECT name, price
FROM product
ORDER BY price;

ORDER BY defaults to ascending