Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
17. Last Person to Fit in the Elevator (Medium)
On this page

Problem Statement

Table: ElevatorQueue

This table stores information about individuals waiting for an elevator. Each row includes a person's ID, their name, their weight, and their position in the queue.

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| person_id     | int     |
| name          | varchar |
| weight        | int     |
| position      | int     |
+---------------+---------+
person_id column contains unique values.
This table contains data about all individuals queuing for an elevator.

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page