Alchemy Database

download the Alchemy database and practise your own queries.

alchemy.db

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):

some practise queries:

select1.sql

SELECT *
FROM Ingredients

select2.sql

SELECT elixir, ingredient
FROM Ingredients

select3.sql

SELECT *
FROM Ingredients
WHERE ingredient = 'Kale'