SQL Practice Logo

SQLPractice Online

Company SQL Question

Total Fare by City

Practice this Uber style SQL interview question with live execution and instant feedback.

Problem Statement

Calculate the total fare amount collected in each city. Show city name and total fare amount, ordered by total fare descending.

Relevant Tables

citiestrips

SQL Concepts Used in This Question

Strengthen your understanding with these targeted learning topics: