-- Database 3: Zelda Temples
-- Query 1
SELECT i.name
FROM Item i, Temple t
WHERE t.tid = i.temple_id AND t.name = 'Forest Temple';

-- Query 2
SELECT t.name as 'temple_name', e.name as 'enemy_name'
FROM Enemies e, Temple t 
WHERE e.first_seen = t.tid 
AND t.name = 'Shadow Temple';

-- Query 3
SELECT i.name 
FROM Item i, Temple t 
WHERE t.tid = i.temple_id AND i.upgrades != NULL
  AND t.name = "Dodongo's Cavern";
-- Could have LIMIT 1 here, would be okay.

-- Query 4
SELECT e.name, e.location 
FROM Enemies e, Temple t, Bosses b 
WHERE e.first_seen = t.tid AND b.temple_id = t.tid 
  AND b.name = 'Twinrova'
ORDER BY e.name DESC;

-- Query 5
SELECT t.name as 'temple_name',
       e.name as 'enemy_name', 
       i.name as 'item_name'
FROM Enemies e, Temple t, Item i 
WHERE t.tid = e.first_seen AND t.tid = i.temple_id AND i.upgrades IS NOT NULL
ORDER BY t.name, i.name;