select1.sql
SELECT * FROM Ingredients
SELECT elixir, ingredient FROM Ingredients
SELECT * FROM Ingredients WHERE ingredient = 'Kale'
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):