Last Weight Before Bus Capacity | Dataford Interview Questions

SQL Query: last weight of person entering bus before it crosses capacity of 1000 kgs

Asked in the technical_round stage. Write a SQL query for bus 1 that identifies the last person who boards while the cumulative passenger weight remains at or below 1000 kg.

Output

Return one row with passenger_name and weight.
Include the last passenger whose boarding keeps cumulative weight at or below 1000 kg.
If later passengers cause the capacity to be exceeded, exclude them. Return the selected passenger first.

Schema

bus_entries

Column	Type	Description
entry_idPK	INT	Unique boarding record identifier
bus_id	INT	Bus identifier
passenger_id	INT	Passenger who boards
entry_order	INT	Order in which the passenger boards
weight	INT	Passenger weight in kilograms

passengers

Column	Type	Description
passenger_idPK	INT	Unique passenger identifier
passenger_name	VARCHAR(100)	Passenger name

Your question is Last Weight Before Bus Capacity. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem