Practice · History · Medium
Return the name and site of every temple whose principal_deity mentions Amun.
Runs in your browser. No signup needed.
temples(name, site, principal_deity). Some deity fields list several gods, so match on a substring with LIKE.
SELECT name, site
FROM temples
WHERE principal_deity LIKE ...;The reference solution is checked automatically when you run your query on the practice page — results are compared row by row.
Amun rose from a local Theban god to king of the gods, which is why so much of Karnak is his. (Touropia)