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 CASE WHEN END STATEMENTS concepts in sql
👉Query -
1)
drop table if exists table1;
CREATE TABLE table1( sid integer,score integer);
INSERT INTO table1( sid,score)
VALUES
('1','72'),
('2','16'),
('3','69'),
('4','43'),
('5','23');
2)
drop table if exists table2;
CREATE TABLE table2(orderid integer,stateid varchar(200),status varchar(200),amount integer);
INSERT INTO table2(orderid,stateid,status,amount)
VALUES
('1','s1','shipped','67050'),
('2','s2','delivered','68608'),
('3','s3','packed','62545'),
('4','s2','shipped','54033'),
('5','s1','delivered','39284'),
('6','s2','shipped','80372'),
('7','s2','delivered','66399'),
('8','s3','packed','48914'),
('9','s1','packed','95459'),
('10','s1','delivered','70493'),
('11','s2','delivered','58017'),
('12','s3','packed','80360'),
('13','s1','delivered','90328'),
('14','s3','shipped','32283'),
('15','s2','packed','62551'),
('16','s3','packed','18273'),
('17','s2','shipped','46131'),
('18','s1','packed','18713');
------------------------------------------------------------------
👉 Complete playlist on Sql Interview questions and answers
[ Ссылка ]
---------------------------------------------------------------------------------------------------------------------
Check out some more relevant content here
👉 How to Learn SQL
[ Ссылка ]
👉 How to become a business analyst complete roadmap-
[ Ссылка ]
👉 How to become a data analyst complete roadmap-
[ Ссылка ]
👉 Top 3 you tube channels to learn sql for free for beginners
[ Ссылка ]
👉 Rank ,Dense Rank, Row Number in sql -
[ Ссылка ]
👉 Cross join in sql
[ Ссылка ]
👉 union join in sql
[ Ссылка ]
👉 left join in sql
[ Ссылка ]
👉 Right join in sql
[ Ссылка ]
👉 Inner join in sql
[ Ссылка ]
👉 Introduction to tables and databases in sql -
[ Ссылка ]
👉 Aggregate Function in sql
[ Ссылка ]
👉 Functions in sql-
[ Ссылка ]
👉 String Function in sql
[ Ссылка ]
👉 CRUD operations in sql
[ Ссылка ]
👉 Autoincrement in sql
[ Ссылка ]
👉 Primary Key in sql-
[ Ссылка ]
👉 Null and Default values in sql-
[ Ссылка ]
👉 Data types in sql-
[ Ссылка ]
____________________________________________________________________
Fill the form below to subscribe yourself to the analytics jobs mailing list to receive regular job opening updates - [ Ссылка ]
Why you should definitely fill the analytics job updates google form - [ Ссылка ]
_______________________________________________________________________
Connect with me
📸Instagram - [ Ссылка ]
💻Linkedin- [ Ссылка ]
_____________________________________________________________________
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
![](https://i.ytimg.com/vi/Sk6pbUiCwD8/maxresdefault.jpg)