write a query to fetch the city name along with earnings from each city

examplequestion2question1[question[][1]4

I've tried this but its throwing error

Select c.name sum(f.fare) from CITIES c ,RIDES f inner join USERS u ON c.id=u.city_id and u.id=f.user_id sort by sum(f.fare);

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum