Most Common Sql Interview Questions 5 | SQL Advanced Questions | Ashutosh Kumar
Sql one of the most important language asked in most of the analytics interviews, in this i will be solving sql questions which was asked to me in one of the company.
1)
drop table if exists table10;
CREATE TABLE table10( user_id integer, start_date date,end_date date);
INSERT INTO table10( user_id ,start_date ,end_date)
VALUES
INSERT INTO table10( user_id ,start_date ,end_date)
VALUES
('1','2020-01-01','2020-01-31'),
('2','2020-01-16','2020-01-26'),
('3','2020-01-28','2020-02-06'),
('4','2020-02-16','2020-02-26');
2)
drop table if exists table9;
CREATE TABLE table9( make_name varchar(200),lead_id integer, date_id date, partner_id integer );
INSERT INTO table9( make_name ,lead_id , date_id , partner_id )
VALUES
('toyota','0','12-08-2020','1'),
('toyota','1','12-08-2020','0'),
('toyota','1','12-08-2020','2'),
('toyota','0','12-07-2020','2'),
('toyota','0','12-07-2020','1'),
('honda','1','12-08-2020','2'),
('honda','2','12-08-2020','1'),
('honda','0','12-07-2020','1'),
('honda','1','12-07-2020','2'),
('honda','2','12-07-2020','1');
3)
drop table if exists table11;
CREATE TABLE table11( id integer,student varchar(200),score integer);
INSERT INTO table11( id ,student ,score)
VALUES
('1','jack','1700'),
('2','alice','2010'),
('3','mike','2200'),
('4','scott','2100');
drop table if exists table8;
CREATE TABLE table8(emp_id INTEGER, in_time INTEGER ,event_day DATE,out_time INTEGER );
INSERT INTO table8( emp_id, in_time, event_day ,out_time)
VALUES
('1','4','11-28-2020','32'),
('1','55','11-28-2020','200'),
('1','1','12-03-2020','42'),
('2','3','11-28-2020','33'),
('2','47','12-09-2020','74');
👉 Complete playlist on Advanced Sql
• Advanced Sql Concepts
👉 Complete playlist on Sql Interview questions and answers
• HackerRank SQL problems and solution
---------------------------------------------------------------------------------------------------------------------
Check out some more relevant content here
👉 Complete sql course from beginner to advance-
• The Ultimate SQL Course for Beginner's to ...
👉 How to Learn SQL
• How to learn sql for beginners | Step by s...
👉 How to become a business analyst complete roadmap-
• Business Analyst Complete Roadmap in 2022 ...
👉 How to become a data analyst complete roadmap-
• Data Analyst Complete Roadmap in 2022 | Fr...
👉 Top 3 you tube channels to learn sql for free for beginners
• Video
👉 Rank ,Dense Rank, Row Number in sql -
• RANK - DENSE RANK - ROW NUMBER IN SQL
👉 Data types in sql-
• Data types in Sql - SQL
____________________________________________________________________
Fill the form below to subscribe yourself to the analytics jobs mailing list to receive regular job opening updates - https://docs.google.com/forms/d/e/1FA...
Why you should definitely fill the analytics job updates google form - • Job Openings into business analyst data an...
_______________________________________________________________________
Connect with me
📸Instagram - / ashutosh.analytics
💻Linkedin- / ashutoszh
_____________________________________________________________________
Comment down if you have any doubts
Please leave a LIKE 👍 and SUBSCRIBE ❤️ to my channel to receive more amazing content in data analytics and data science.
_____________________________________________________________________
🏷️ Tags
sql,
sql for data science,
sql for data analytics,
sql practise questions,
sql practise questions and solutions,
sql tutorials for beginners,
sql problems for data engineers,
ashutosh,
ashutosh kumar,
ashutosh kumar analytics,
sql problems easy,
sql problem medium,
sql problems hard,
sql window functions,
sql advanced questions,
rank functions in sql,
lag lead in sql,
sql interview questions and answers,
sql interview questions,
sql questions asked in interviews,
hackerrank sql solutions,
hackerearth sql solutions,
leetcode sql solution
🏷️HashTags
#sql #interviews #questions #solutions