Can someone help with my query they want only cities with 5 star but they want a specific amount per city if you can look at question 3 please and give me feedback.

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. 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 { FROM grp } \\ 54 & \text { JOIN city on grp.city_id = city.city_id } \\ 55 & \text { WHERE city = "New York" AND rating = } 5 \\ 56 \text { 63 } & \text { WHERE city = "Chicago" AND rating = } 5 \\ 57 & \text { WHERE city = "San Fransico" AND rating = } 5 \\ 58 & \text { ORDER BY members desc; } \\ 59 & \\ 60 & \\ 61 & \end{array} \)