Sql one of the most important language asked in most of the analytics interviews,in this series i have discussed some advanced level sql concepts that are frequently asked in data analyst,business analyst interviews. In this video i have covered non equi joins concepts in sql
Query
drop table if exists order_summary;
CREATE TABLE order_summary(orderid integer,amount integer,quantity integer);
INSERT INTO order_summary(orderid,amount,quantity)
VALUES (1,4922,8),
(2,7116,8),
(3,1206,4),
(4,2841,7),
(5,2522,2),
(6,5084,3),
(7,6680,4),
(8,8123,7),
(9,6015,2),
(10,4092,3),
(11,7224,2),
(12,7679,8),
(13,1303,2),
(14,5185,7),
(15,2139,8);
drop table if exists customer;
CREATE TABLE customer(cust_id integer,cust_first_name text,cust_last_name text);
INSERT INTO customer(cust_id,cust_first_name,cust_last_name)
VALUES (1,'Henry','Brown'),
(2,'James','Williams'),
(3,'Jack','Taylor');
drop table if exists orders;
CREATE TABLE orders(order_id integer,date date,cust_id integer);
INSERT INTO orders(order_id,date,cust_id)
VALUES
(1,'05082020',1),
(2,'04082020',2),
(3,'03082020',3),
(4,'04082020',1),
(5,'05082020',2),
(6,'05082021',3),
(7,'04082021',1),
(8,'03082021',2),
(9,'04082021',3),
(10,'05082021',2),
(11,'05082022',1),
(12,'04082022',2),
(13,'03082022',3),
(14,'04082022',1),
(15,'05082022',2);
select * from orders;
select * from order_summary;
select * from customer;
Complete playlist on Sql Interview questions and answers
• HackerRank SQL problems and solution
Check out some more relevant content here
How to Learn SQL
• How to learn sql for beginners | Step...
How to become a business analyst complete roadmap
• Business Analyst Complete Roadmap in ...
How to become a data analyst complete roadmap
• Data Analyst Complete Roadmap in 2022...
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
Cross join in sql
• CROSS JOIN SQL
union join in sql
• UNION IN SQL
left join in sql
• LEFT JOIN IN SQL
Right join in sql
• RIGHT JOIN IN SQL
Inner join in sql
• INNER JOIN IN SQL
Introduction to tables and databases in sql
• INTRO TO TABLES AND DATABASES IN SQL ...
Aggregate Function in sql
• AGGREGATE FUNCTION IN SQL
Functions in sql
• IMPORTANT FUNCTIONS IN SQL
String Function in sql
• STRING FUNCTIONS IN SQL
CRUD operations in sql
• CREATE READ UPDATEDELETE CRUD IN SQL
Autoincrement in sql
• Auto Increment in SQL SQL
Primary Key in sql
• PRIMARY KEYS IN SQL SQL
Null and Default values in sql
• NULL AND DEFAULT VALUES IN SQL 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 da...
_______________________________________________________________________
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