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 -
[ Ссылка ]

Medium - Level questions -
[ Ссылка ]
Hard-Level SQL interview questions -
[ Ссылка ]

If you have any interesting SQL questions, feel free to send them to me at
kulkarnisneha891@gmail.com.

#sqlqueryinterviewquestionsandanswers
#microsoft #dell #flipkart
#sql #sqlqueries #dataanalytics
#data #database #faangpreparation



#sqlserver #dataanalytics #dataanalyst
#sqlqueries

свернуть