SQL playground

CREATE TABLE snacks (name TEXT, price REAL, crunchy INTEGER);
INSERT INTO snacks VALUES
  ('Crisps', 1.20, 1),
  ('Chocolate', 1.50, 0),
  ('Pretzels', 0.99, 1),
  ('Gummy bears', 1.10, 0);

SELECT name, price
FROM snacks
WHERE crunchy = 1
ORDER BY price;