This playlist contains scenario based SQL problems. After solving these you should be able to ace any SQL interview. As and when I find a good problem, i will add it to this playlist.
Curated by: Ankit Bansal (96 videos)
In this video we will discuss a scenario based SQL problem. I will be solving it using Analytical function. You will learn how to use Lead analytical function with partition by clause and how to deal with data ranges in SQL. Here is the ready script: create table billings ( emp_name varchar(10), bill_date date, bill_rate int ); delete from billings; insert into billings values ('Sachin','01-JAN-1990',25) ,('Sehwag' ,'01-JAN-1989', 15) ,('Dhoni' ,'01-JAN-1989', 20) ,('Sachin' ,'05-Feb-1991', 30) ; create table HoursWorked ( emp_name varchar(20), work_date date, bill_hrs int ); insert into HoursWorked values ('Sachin', '01-JUL-1990' ,3) ,('Sachin', '01-AUG-1990', 5) ,('Sehwag','01-JUL-1990', 2) ,('Sachin','01-JUL-1991', 4) #sql #scenariobased #interview