select1.sql

SELECT *
FROM Ingredients

.sql
select2.sql

SELECT elixir, ingredient
FROM Ingredients

.sql
select3.sql

SELECT *
FROM Ingredients
WHERE ingredient = 'Kale'

.sql

download the Alchemy database and practise your own queries.

you can browse structure of alchemy.db to see tables, and their columns:

to see table data, click browse data:

you can make new records, but the record has to "fit in" with the rules of the table (more on table constraints later):