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

Which statement describes a way in which Russia differed from western Europe in the seventeenth and eighteenth centuries? A. Most Russians of all classes were O

In the 1980s, Bush proposed legislation to save the banking industry at a cost of millions of dollars. billions of dollars. thousands of dollars. trillions of d

When Muslims speak of “people of the book,” to whom are they referring? Bedouins Christians Arabs Pilgrims

When did Japan surrender? A. after the first atomic bomb was dropped B. the day the Soviet Union invaded Manchuria C. the day after Germany and Italy surrendere

Should Maria rent or buy? Maria, age 21, plans to work full time while completing her college degree in a nearby city. I would think she should rent but I don'

Under the eighth amendment a person charged with a crime has to do what ?

Two similar cylinders have a scale factor of 1.6/3. Find the ratio of their volumes.

What foreign-policy approach did Ronald Reagan promise to take if he was elected in 1980? He promised to sign the INF Treaty. He promised to build a strong mili

Which was Henry Ford's primary goal in starting the Ford Motor Company? A. to compete with the success of Thomas Edison's Invention Factory B. to change the way

Repressed Brits, Evil Mexicans, Arab Villains: Why are Hollywood's animated movies full of racist stereotypes? The article identifies a ''tacit racial hierarchy

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.