SQL Interview questions & Answers | Part-5
This is the 5th video of our series on SQL interview questions and answers. This series is specifically designed for people targeting jobs as data analysts, data scientists, data engineers, business analysts and Software Engineer. Also this video is helpful for those students who are studying in Computer Science Engineering and AI and DSA.
In this video, I have explained Answer for
Problem Statement:-
Write a SQL code to find employees hired in last ‘N’ months/day/year
Use below script to create the Tables:-
Create Employee Table
Create table Employee
(
ID int primary key auto_increment,
FirstName varchar(50),
LastName varchar(50),
Gender varchar(50),
Salary int,
HireDate Date
);
Insert records in Employee Table
INSERT INTO Employee (FirstName, LastName, Gender, Salary, HireDate)
VALUES
('Mark', 'Hastings', 'Male', 60000, '2023-10-05'),
('Steve', 'Pound', 'Male', 45000, '2023-04-20'),
('Ben', 'Hoskins', 'Male', 70000, '2023-04-05'),
('Philip', 'Hastings', 'Male', 45000, '2023-03-11'),
('Mary', 'Lambeth', 'Female', 30000, '2023-03-10'),
('Valarie', 'Vikings', 'Female', 35000, '2023-02-09'),
('John', 'Stanmore', 'Male', 80000, '2023-02-22'),
('Able', 'Edward', 'Male', 5000, '2023-01-22'),
('Emma', 'Nan', 'Female', 5000, '2023-01-14'),
('Jd', 'Nosin', 'Male', 6000, '2023-01-10'),
('Todd', 'Heir', 'Male', 7000, '2023-02-14'),
('San', 'Hughes', 'Male', 7000, '2023-03-15'),
('Nico', 'Night', 'Male', 6500, '2023-04-19'),
('Martin', 'Jany', 'Male', 5500, '2023-05-23'),
('Mathew', 'Mann', 'Male', 4500, '2023-06-23'),
('Baker', 'Barn', 'Male', 3500, '2023-07-23'),
('Mosin', 'Barn', 'Male', 8500, '2023-08-21'),
('Rachel', 'Aril', 'Female', 6500, '2023-09-14'),
('Pameela', 'Son', 'Female', 4500, '2023-10-14'),
('Thomas', 'Cook', 'Male', 3500, '2023-11-14'),
('Malik', 'Md', 'Male', 6500, '2023-12-14'),
('Josh', 'Anderson', 'Male', 4900, '2024-01-05'),
('Geek', 'Ging', 'Male', 2600, '2024-01-04'),
('Sony', 'Sony', 'Male', 2900, '2024-04-30'),
('Aziz', 'Sk', 'Male', 3800, '2024-03-01'),
('Amit', 'Naru', 'Male', 3100, '2024-03-31');
Join My Telegram Channel to download the notes👇:
Telegram : https://t.me/+SphVEMyx2m02NWJl
⚠️Don't Forget to Subscribe My Channel !
Follow me on👇
Instagram : / sagar.dodamani
LinkedIn : / sagardodamani
GitHub : https://github.com/Dodamanisagar
Telegram : https://t.me/+SphVEMyx2m02NWJl
#sql
#sqlinterview
#sqlinterviewquestionsandanswers
#sqlinterviewquestions
#dataanalyst
#datascience
Смотрите видео SQL Interview questions & Answers | Part-5 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Sagar's Data Journey 23 Август 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 325 раз и оно понравилось 9 людям.