Data Analytics Interview
0 of 84 Completed
Introduction to medium SQL questions
1m read
DATETIME
2m read
Self-JOINs and CROSS JOINs
2m read
Subqueries and CTEs
3m read
Daily Logins
Question
Employee Salaries (ETL Error)
Question
Slacking Employees Salaries
Question
CASE clause
1m read
Exam Scores
Question
Customer Orders
Question
Employee Salaries (Top 3 departments)
Question
Handling NULL values
1m read
Empty Neighborhoods
Question
Distance Traveled
Question
LIKE and other useful functions
2m read
Window Functions
2m read
Last Transaction
Question
Top Three Salaries
Question
User Experience Percentage
Question
Distance Traveled
Given the tables users and rides, write a query to report the distance traveled by each user in descending order.
Example:
Input:
users table
| Column | Type |
|---|---|
id |
INTEGER |
name |
INTEGER |
rides table
| Column | Type |
|---|---|
id |
INTEGER |
passenger_user_id |
INTEGER |
distance |
FLOAT |
Output:
| Column | Type |
|---|---|
name |
VARCHAR |
distance_traveled |
FLOAT |
0%
CompletedYou have 84 sections remaining on this learning path.
Loading pricing options.