What is the most populated city in California?
in California refers to state = 'CA'; most populated city refers to Max(population)
SELECT city_name FROM city WHERE state = 'California' AND population = ( SELECT MAX(population) FROM city WHERE state = 'California' )