Interview Query
Back to Data Engineering Interview
Data Engineering Interview

Data Engineering Interview

23 of 73 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
Go to question details page

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
Empty Neighborhoods
LIKE and other useful functions
Good job, keep it up!

31%

Completed

You have 50 sections remaining on this learning path.