DP-600: Implementing Analytics Solutions Using Microsoft FabricDemo

Question

You have a Fabric warehouse named Warehouse1 that contains a table named TaxiTrips.

TaxiTrips contains the following columns.

Question Image

You need to create a query that shows the top three taxi companies based on the total miles traveled.

How should you complete the T-SQL statement?

Select

SELECT 
    company AS TaxiCompany,
    sum(passengerCount) AS TotalPassengers,
    sum(tripDistance) TotalDistance
FROM [Warehouse1].[dbo].[TaxiTrips]

 DESC;

Explanation

TOP (3) limits the result to three rows. Company must be the GROUP BY expression because it is the non-aggregated selected column; SUM(tripDistance) calculates total miles per company. Sorting that aggregate in descending order places the companies with the greatest total mileage first.

Learn more

DP-600: Implementing Analytics Solutions Using Microsoft FabricDemo

AstroTutor

Notes

Readiness

QuestionQ84

Community Discussion