CASE12:need final list of passengers allowed to enter the lift based on the max capacity of the lift
In this problem, we are given information about Lifts and Passengers. We need to come up with the final list of passengers allowed to enter the lift based on the maximum capacity of the lift.
Practice Solving INTERMEDIATE SQL Queries
In this video, I solve a REAL SQL Interview PROBLEM asked by Capgemini. This problem was shared with me by someone who took this interview.
create table lifts
(
id int
, capacity_kg int
);
insert into lifts values (1, 300);
insert into lifts values (2, 350);
create table lift_passengers
(
passenger_name varchar(50)
, weight_kg int
, lift_id int
);
Hi, this is Rajanikanth Gaja and I post videos on Computer Science related concepts, especially data-related technologies, these videos will help you in interviews as well as in clearing your theory and coding questions. If this channel helped you even a bit, please consider subscribing to the channel.
If you need any personal help in SQL, Mock interviews, or Coding help You can contact me at [email protected], Please note it will be charged.
Thank you :)
✨ Work-related E- emails can be sent to: [email protected]