Top Sql Interview Questions | 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. Query drop table if exists transactions; CREATE TABLE transactions(transaction_id integer,userid integer,created_at date ,updated_at date,status text,amount int); INSERT INTO transactions(transaction_id,userid,created_at,updated_at,status,amount) VALUES (1,1,'04-19-2017','04-21-2017','Fail',105), (2,3,'12-18-2019','12-19-2019','Success',215), (3,2,'07-20-2020','07-23-2020','Success',416), (4,1,'10-23-2019','10-26-2019','Fail',410), (5,1,'03-19-2018','03-22-2018','Success',254), (6,3,'12-20-2016','12-23-2016','Fail',227), (7,1,'11-09-2016','11-11-2016','Success',351), (8,1,'05-20-2016','05-23-2016','Success',110), (9,2,'09-24-2017','09-27-2017','Success',135), (10,1,'03-11-2017','03-14-2017','Fail',281), (11,1,'03-11-2016','03-12-2016','Success',57), (12,3,'11-10-2016','11-11-2016','Success',417), (13,3,'12-07-2017','12-08-2017','Fail',385), (14,3,'12-15-2016','12-16-2016','Success',329), (15,2,'11-08-2017','11-10-2017','Fail',67), (16,2,'09-10-2018','09-13-2018','Success',233); drop table if exists customer; CREATE TABLE customer(userid integer,date date); INSERT INTO customer(userid,date) VALUES (1,'09-22-2009'), (2,'09-10-2011'), (3,'04-21-2015'); select * from customer ; select * from transactions; 👉 Complete playlist on Advanced Sql https://youtube.com/playlist?list=PLbTF1OfX62c3RQ_ZFfyNBWVPdz_OWTMLG 👉 Complete playlist on Sql Interview questions and answers https://youtube.com/playlist?list=PLbTF1OfX62c3VFYy8aj9e07W7RouhzNMQ --------------------------------------------------------------------------------------------------------------------- Check out some more relevant content here 👉 How to Learn SQL https://youtu.be/OQcFaPUu6WE 👉 How to become a business analyst complete roadmap- https://www.youtube.com/watch?v=83tPvl450F4 👉 How to become a data analyst complete roadmap- https://www.youtube.com/watch?v=FqlzEJ0qdAk&t=1s 👉 Top 3 you tube channels to learn sql for free for beginners https://www.youtube.com/watch?v=z_9Ft4gMk0k&t=1s 👉 Rank ,Dense Rank, Row Number in sql - https://www.youtube.com/watch?v=PwYfGF07EfA 👉 Cross join in sql https://www.youtube.com/watch?v=Ke0kzJG4ljU 👉 union join in sql https://www.youtube.com/watch?v=ldid4rqd2xw&t=1s 👉 left join in sql https://www.youtube.com/watch?v=ssMjUdMkh9w 👉 Right join in sql https://www.youtube.com/watch?v=QnnUclUqUqA 👉 Inner join in sql https://www.youtube.com/watch?v=WcYbs-A9CHU&t=1s 👉 Introduction to tables and databases in sql - https://www.youtube.com/watch?v=Ys9WTXRzOoY&t=1s 👉 Aggregate Function in sql https://www.youtube.com/watch?v=OpAfWSyc2Jw 👉 Functions in sql- https://www.youtube.com/watch?v=Zb00gZ7TM54 👉 String Function in sql https://www.youtube.com/watch?v=_4L18EnlJ1g 👉 CRUD operations in sql https://www.youtube.com/watch?v=DWpclQ_D0HI 👉 Autoincrement in sql https://www.youtube.com/watch?v=kR7sVWEsJnQ 👉 Primary Key in sql- https://www.youtube.com/watch?v=RTyzieEwQjw 👉 Null and Default values in sql- https://www.youtube.com/watch?v=TIgtFe9Nr-0 👉 Data types in sql- https://www.youtube.com/watch?v=7r3DPnbGX0g&t=1s ____________________________________________________________________ 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/1FAIpQLSdT6-6XGaVR_WaCP-TkfdMF-z6G_T9tBDzQp8L-14S3y_xREw/viewform Why you should definitely fill the analytics job updates google form - https://youtube.com/shorts/WcKg3pFYujM?feature=share _______________________________________________________________________ Connect with me 📸Instagram - https://www.instagram.com/ashutosh.analytics 💻Linkedin- https://www.linkedin.com/in/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