In this video, we will solve the SQL Medium Level interview questions asked in Flipkart , Microsoft & Dell
SQL Script:
-- Create the Logins table
CREATE TABLE Logins (
user_id INT,
time_stamp DATETIME
);
-- Insert the data into the Logins table
INSERT INTO Logins (user_id, time_stamp)
VALUES
(6, '2020-06-30 15:06:07'),
(6, '2021-04-21 14:06:06'),
(6, '2019-03-07 00:18:15'),
(8, '2020-02-01 05:10:53'),
(8, '2020-12-30 00:46:50'),
(2, '2020-01-16 02:49:50'),
(2, '2019-08-25 07:59:08'),
(14, '2019-07-14 09:00:00'),
(14, '2021-01-06 11:59:59');
CREATE TABLE Users (
user_id INT PRIMARY KEY,
name NVARCHAR(50)
);
-- Insert values into the Users table
INSERT INTO Users (user_id, name)
VALUES
(1, 'aLice'),
(2, 'bOB');
Easy - Level questions -
https://youtube.com/playlist?list=PLP8zk3fCtbPIRr92ZlRnw6H__IgWQdetg&si=-HgJ2ZeVg1IL35f3
Medium - Level questions -
https://youtube.com/playlist?list=PLP8zk3fCtbPI6zpFi9-BENOuzCtUpMUwe&si=O1m4aK2fupBozHNt
Hard-Level SQL interview questions -
https://youtube.com/playlist?list=PLP8zk3fCtbPK-D8N_jInxlPNaDdlwEjHJ&si=gHH5avPPSunyM6Jx
If you have any interesting SQL questions, feel free to send them to me at
[email protected].
#sqlqueryinterviewquestionsandanswers
#microsoft #dell #flipkart
#sql #sqlqueries #dataanalytics
#data #database #faangpreparation
#sqlserver #dataanalytics #dataanalyst
#sqlqueries