MySQL™: The World’s Most Popular Open Source Database 165 4.1: Subqueries • Scalar Subqueries – SELECT Country, Inhabitants, Area FROM World.Country WHERE Area > (SELECT Area FROM World.Country WHERE Country=’Finland’); • Correlated Subqueries – SELECT * FROM World.City WHERE City.Country = ANY (SELECT Country FROM World.Country WHERE City.Inhabitants > Country.Inhabitants/4); • WHERE field IN (SELECT ... – SELECT * FROM World.Country WHERE Country IN (SELECT Country FROM World.City WHERE City.Inhabitants > 5000000); Copyright 2003 MySQL AB