Can someone help I get error "unkown column city.name in field list". This was a recommendation by a tutor.

3. Adjust your previous query to include the city for each group to ensure you are selecting five groups: three from New York, one from Chicago, and one from San Francisco. HINT You'll need to JOIN the city table to access the city names. \( \begin{array}{ll}48 & \text { SELECT } \\ 49 & \text { grp.city_id, } \\ 50 & \text { group_name } \\ 51 & \text { rating, } \\ 52 & \text { members, } \\ 53 & \text { city.name } \\ 54 & \text { FROM grp } \\ 55 & \text { JOIN city on grp.city_id = city-city_id } \\ 56 & \text { WHERE(city.name = "New York" AND rating }=5 \text { ) OR } \\ 57 & \text { (city.name = "Chicago" AND rating = 5) OR } \\ 58 & \text { (city-name = "San Fransico" AND rating = 5) } \\ 59 & \text { ORDER BY members desc } \\ 60 & \text { LIMIT } 5 ;\end{array} \)