Revature Interview Questions
Revature Interview Guides
Revature Interview Questions
Practice for the Revature interview with these recently asked interview questions.
| Question | Topic | Difficulty | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL | Medium | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
You’re working as a data analyst at Delta Airlines, and you’re provided with two tables: Write a SQL query to list all flights scheduled between Mumbai ( Schema:Input Tables:
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Column | Type |
|---|---|
| flight_id | INTEGER |
| origin | VARCHAR |
| destination | VARCHAR |
| departure_time | DATETIME |
| arrival_time | DATETIME |
| aircraft_id | INTEGER |
aircrafts
| Column | Type |
|---|---|
| aircraft_id | INTEGER |
| model | VARCHAR |
| capacity | INTEGER |
Output:
| Column | Type |
|---|---|
| origin | VARCHAR |
| destination | VARCHAR |
| departure_time | DATETIME |
| aircraft_model | VARCHAR |
| capacity | INTEGER |
Example:
Input Tables:
flights
| flight_id | origin | destination | departure_time | arrival_time | aircraft_id |
|---|---|---|---|---|---|
| 1 | BOM | DEL | 2025-11-19 08:00 | 2025-11-19 10:00 | 201 |
| 2 | DEL | BLR | 2025-11-19 11:00 | 2025-11-19 13:00 | 202 |
aircrafts
| aircraft_id | model | capacity |
|---|---|---|
| 201 | A320 | 180 |
| 202 | B737 | 160 |
Output:
| origin | destination | departure_time | aircraft_model | capacity |
|---|---|---|---|---|
| BOM | DEL | 2025-11-19 08:00 | A320 | 180 |
Explanation:
The flight from BOM → DEL uses aircraft 201 with capacity 180, which is greater than the average capacity of all aircrafts. Hence, it is included in the output.
SQL | Easy | |
Machine Learning | Medium | |
Statistics | Medium | |
SQL | Hard | |
Machine Learning | Medium | |
Python | Easy | |
Deep Learning | Hard | |
SQL | Medium | |
Statistics | Easy | |
Machine Learning | Hard |
Challenge
Check your skills...
How prepared are you for working at Revature?
Revature Salaries by Position
Most data science positions fall under different position titles depending on the actual role.
From the graph we can see that on average the Software Engineer role pays the most with a $81,667 base salary while the Software Engineer role on average pays the least with a $81,667 base salary.
Discussion & Interview Experiences