3. Maximum Distance
A ride hailing company has their DB structured in 3 major tables as described in the SCHEMA section below.
Write a query to fetch the top 100 users who traveled the most distance using the service. The output should be stru
users.name distance_traveled
Sort the output by distance traveled in descending order, then by the user name in ascending order. Show only the top 100 users,
ignoring the ties at the last position.
Note: There could be multiple users with the same name but they will have different IDs.
Schema
You are provided 3 tables: CITIES, USERS, and RIDES.
CITIES
Name Type
Description
id
String The assigned ID to the city presented as 32 character UUID.
name
String The name

Question

14-06-2022
Computers and Technology

contestada

3. Maximum Distance
A ride hailing company has their DB structured in 3 major tables as described in the SCHEMA section below.
Write a query to fetch the top 100 users who traveled the most distance using the service. The output should be stru
users.name distance_traveled
Sort the output by distance traveled in descending order, then by the user name in ascending order. Show only the top 100 users,
ignoring the ties at the last position.
Note: There could be multiple users with the same name but they will have different IDs.
Schema
You are provided 3 tables: CITIES, USERS, and RIDES.
CITIES
Name Type
Description
id
String The assigned ID to the city presented as 32 character UUID.
name
String The name

Respuesta :

Otras preguntas

This leader's policies pushed Germany toward war. Otto von Bismarck Kaiser Wilhelm Otto von Wilhelm Kaiser von Bismarck ----------- Q2: One of the major

An ant carries food at a speed of 1 cm/s. How long will it take the ant to carry a cookie crumb from the kitchen table to a the ant hill, a distance of 50 m? Ex

what does the sea symbolize in The Old Man and the Sea

Which cell is the precursor to eukaryotic in evolution of the cell

the activities of martin luther king jr., rosa parks, and the NAACP in montgomery in 1955 and 1956 are most accurately examples of

The sum of two consecutive interfere is 7

where did the term manifest destiny come from? what does it mean?

There are 25 gold cards and 25 silver cards in a deck. The gold cards are number 1,3,5,.....49 and the silver cards are numbered 2,4,6,.....50. The cards are th

PLease Help ASAP>>American leaders hoped that Nixon's Vietnamization program would have the following three results: -show North Vietnam that the United

What is the term for an interbreeding group of organisms that can produce offspring that are fertile? A. genus B. biological species C. ecosystem D. popula

saimaparvezVT saimaparvezVT · Answer 1 · 2022-06-21T20:44:49+02:00

A query to fetch the top 100 users who traveled the most distance using the service is SQL COUNT(column_name) Syntax. The COUNT(column_name) feature returns a variety of values.

Which question can fetch statistics from consumer desk and taken care of ascending ORDER BY first name?

The ORDER BY assertion in SQL is used to type the fetched records in both ascending or descending consistently with one or greater columns. By default ORDER BY kinds the records in ascending order. We can use the keyword DESC to type the records in descending order and the key-word ASC to type in ascending order.

SQL COUNT(column_name) Syntax. The COUNT(column_name) feature returns the variety of values (NULL values will now no longer be counted) of the desired column:
SQL COUNT() Syntax. The COUNT() feature returns a variety of statistics in a desk:
SQL COUNT(DISTINCT column_name) Syntax.
The SQL ORDER BY Keyword.