Top 5 Advanced SQL Interview Questions and Answers | Frequently Asked SQL interview questions

In this video we will discuss most frequently asked top 5 Advanced SQL interview questions for experienced. We will also cover different variations of each questions. If you have any interview I am sure 2-3 questions will be from this list.

Zero to hero(Advance) SQL Aggregation:

Most Asked Join Based Interview Question:

Solving 4 Trick SQL problems:

Data Analyst Spotify Case Study:

Top 10 SQL interview Questions:

Interview Question based on FULL OUTER JOIN:

Playlist to master SQL :

Rank, Dense_Rank and Row_Number:

#sql #analytics

[ankitbansal]

Here is the detailed explanation of question number 5. Please do like the video to help me reach to more people. Thanks in advance 🙏🙏
Most asked SQL interview question:

[addhyasumitra]

create table emp(
emp_id int,
emp_name varchar(20),
department_id int,
salary int,
manager_id int,
emp_age int);


insert into emp
values (1, 'Ankit', 100, 10000, 4, 39);
insert into emp
values (2, 'Mohit', 100, 15000, 5, 48);
insert into emp
values (3, 'Vikas', 100, 10000, 4, 37);
insert into emp
values (4, 'Rohit', 100, 5000, 2, 16);
insert into emp
values (5, 'Mudit', 200, 12000, 6, 55);
insert into emp
values (6, 'Agam', 200, 12000, 2, 14);
insert into emp
values (7, 'Sanjay', 200, 9000, 2, 13);
insert into emp
values (8, 'Ashish', 200, 5000, 2, 12);
insert into emp
values (1, 'Saurabh', 900, 12000, 2, 51);

[llciii]

I love the fact that you explained keywords that’ll give you an idea of how of to solve the problem 👏🏾👏🏾👏🏾. I’ve just subbed to your channel and liked the video

[prateekkumar-xcuo]

Hello Ankit, excellent explanation of sql concepts thanks for sharing with all . could you pls share the dataset for this?

[heyrobined]

Make More videos These are really good coverage of what kind of questions asked by companies

[rakesh_bangla]

You are a great teacher, Ankit Sir! Thank you for the valuable knowledge.

[rajasekhardondati]

Excellent explanation Ankit. Thank you. Can you please provide emp, order table datasets .so, that we can practice the same.

[JeetendraKasi]

Excellent explanation using data and common mistakes that someone can do while querying the data.

[MubarakAli-qsqq]

No bakwass, only crisp and clear sql coding❤

[MubarakAli-qsqq]

Sir i watched many vedios but could not understand CTE but this one made me understand hats off sir

[namangarg]

Fantastic Ankit bhai...all begineer shud tks u for such great learning

[NEHAKHANZODE-pp]

Hi Ankit, I have tried multiple times for -YOY growth for product with current month sales more than previous moth sales

Could you just correct me if my query is wrong?


here is my query for the same:


with cte as (
select product_id, month(order_date) as month_order, year(order_date) as year_order, sum(sales) as sales
from Orders
group by product_id, month(order_date), year(order_date)

),
cte2 as
(select *, lag(sales, 1) over( partition by product_id order by month_order, year_order) as previous_month_sales
from cte
)
select *

from cte2
where sales>previous_month_sales ;

[dfkgjdflkg]

As usual, I love your content. Original, helpful and puzzling how you find the solutions. Original content

[temik]

Hi Ankit,
Thank you for what you're doing. Very interesting scenarios. How can one get access to the table's data pls? I was able to create the employee table for practice but the order table was not visible enough as it's more volumunous. This will be helpful for practice purpose. Many thanks

[sriharsha]

Thank you sir for such valuable content with a clean explanation sir

[NEHAKHANZODE-pp]

Thank you so much for this video! Your explanation was so clear and easy to understand. I’ve been struggling with this concept for a while, and your content really made it click for me. Keep up the amazing work!

[akashjha]

Excellent explanation sir, slow and clear

[guiltycrown]

thanks for addressing such important questions ..

[bhuwneshchaudhary]

Bro, top 2 will run before the order by clause because in sql order of execution select statement runs before the order by statement

[vishalchakraborty]

Thanks Ankit 🙏
You make sql so easy to understand 🤌🤌