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

Рет қаралды 39,058

3 ай бұрын

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.
Kick off your data analytics journey: www.namastesql.com/
Zero to hero(Advance) SQL Aggregation:
• All About SQL Aggregat...
Most Asked Join Based Interview Question:
• Most Asked SQL JOIN ba...
Solving 4 Trick SQL problems:
• Solving 4 Tricky SQL P...
Data Analyst Spotify Case Study:
• Data Analyst Spotify C...
Top 10 SQL interview Questions:
• Top 10 SQL interview Q...
Interview Question based on FULL OUTER JOIN:
• SQL Interview Question...
Playlist to master SQL :
• Complex SQL Questions ...
Rank, Dense_Rank and Row_Number:
• RANK, DENSE_RANK, ROW_...
#sql #analytics

Пікірлер: 87

@ankitbansal6 3 ай бұрын

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: kzfaq.info/get/bejne/rrhoasaltM3UcXk.html

@SinghSahab-gg1ow 3 ай бұрын

request to u pls pls provide same data for practice

@nikhilsharma-jj6vd 3 ай бұрын

Hi Sir, I recently got a sql question in HackerRank Interview for Techincal support engineer. Can you give us a solution. If yes, how can I send you the question please revert sir

@ankitbansal6 3 ай бұрын

@@nikhilsharma-jj6vd send it on sql.namaste@gmail.com

@nikhilsharma-jj6vd 3 ай бұрын

@@ankitbansal6 sure sir. Sir I've also sent you request on LinkedIn. Please accept

@nikhilsharma-jj6vd 3 ай бұрын

@@ankitbansal6 sent sir please check

@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

@heyrobined 3 ай бұрын

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

@JeetendraKasi 2 ай бұрын

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

@sriharsha398 3 ай бұрын

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

@aman_mashetty5185 3 ай бұрын

Great video as usual awesome....!👏👏

@akashjha7277 3 ай бұрын

Excellent explanation sir, slow and clear

@prateekkumar-xc6uo 3 ай бұрын

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

@varunl6948 3 ай бұрын

This was helpful!

@aadarshchaudhari3957 3 ай бұрын

Great explanation 👏

@dfkgjdflkg 3 ай бұрын

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

@ankitbansal6 3 ай бұрын

Glad you enjoy it!

@shwetamishra1497 3 ай бұрын

Very informative video. Please provide us data for practice.

@vamsivamsi2029 3 ай бұрын

Thanks ankit

@udhaybhaskarbellamkonda1678 3 ай бұрын

Good Content,Keep it up 😊

@zuhebkhan6973 2 ай бұрын

Thanks in advance

@vinayakacn401 18 сағат бұрын

nice video, very informative and precise, thanks keep up the work

@kaustavraytalukdar5466 3 ай бұрын

Helpful video, dataset please.

@Nivethan303 15 күн бұрын

This is very useful 👌

@Udayakumar_K 3 ай бұрын

Really like your content. Please create for python also

@temik6500 3 ай бұрын

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

@user-js2vt3nz2k Ай бұрын

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!

@ankitbansal6 Ай бұрын

You are so welcome!

@gauravsati1041 3 ай бұрын

Its very informative video, can you please share the dataset also?

@raghibelahi937 Ай бұрын

Thank you so much sir. Could you please share the dataset.

@sandeepanand3834 Сағат бұрын

you deserve more subscriber :)

@prabhac2273 2 ай бұрын

Excellent and clear explanation. Thanks for uploading.

@ankitbansal6 2 ай бұрын

You are welcome!

@niharranjandhar3457 3 ай бұрын

Inner 8 Left 8 Right 9

@chiranjitdey3788 3 ай бұрын

Hi Ankit, Can you help solve this question. This question was asked to me in one of the interviews for data analyst position. Write an SQL query to find out the employees whose salary got increased at least 115% compared to the previous maximum salary. The result output should contain the following columns such as employee_name, salary, and salary_growth_percentage.

@SunilKumar_67 Ай бұрын

Great efforts in educating us. Thank you Ankit

@ankitbansal6 Ай бұрын

It's my pleasure🙏

@shikharsaxena8984 3 ай бұрын

Very helpful video Ankit 👏👏🙂

@ankitbansal6 3 ай бұрын

Glad to hear that

@madhustips8304 3 ай бұрын

really awesome content

@ankitbansal6 3 ай бұрын

Thank you 😊

@user-js2vt3nz2k Ай бұрын

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 ;

@sravankumar1767 2 ай бұрын

Superb explanation Ankit👌 👏 👍

@ankitbansal6 2 ай бұрын

Thank you 🙂

@anikeetdey3411 3 ай бұрын

plz share the insert query , so that we can practice along with you

@sonalpriya6402 3 ай бұрын

Please share dataset for practice

@sravyasrinivas 3 ай бұрын

Hi ankit. Could you please share the DDL script for these questions.

@rk-ej9ep 3 ай бұрын

This is awesome..I subscribed to ur paid course also..

@ankitbansal6 3 ай бұрын

Great. Thankyou 😊

@krsnabnsl 2 ай бұрын

Hi @Ankit, can you please provide data link, so we can test on your own.

@minakshityagi7785 3 ай бұрын

How to find roling quater sales? Ankit Sir can you reply with sql query?

@Robert-uw8dn 3 ай бұрын

Hey Ankit, could you please share the data to practice

@nevergiveup3475 3 ай бұрын

First comment❤

@Mju98 24 күн бұрын

Hi ankit. Please attach the datasets which u used for each video

@macx8360 3 ай бұрын

sir dataset plz

@yashpratap9045 Ай бұрын

Hello Ankit, love your content and the way you explain things it makes easy for anyone to understand these concepts. Regarding the top 5 products per category question, if we apply the row number with other conditions in a single CTE and then filter it based rn to fetch top 5 products ( please see the query below ). I just wanted to understand by combining everything in a single CTE, are there any edge cases that will not work with this approach? Looking forward to hearing from you! WITH CTE AS (SELECT Category, Product_ID, Sum(Sales) as sales, row_number() over(partition by Category order by sum(Sales) DESC) as rn FROM Orders GROUP BY Category, Product_ID) SELECT * FROM CTE WHERE rn

@ankitbansal6 Ай бұрын

This is also fine

@yashpratap9045 Ай бұрын

@@ankitbansal6 thank you!!

@Chetan_15 2 ай бұрын

Q1. i want to show top 3 salllary employee but i used * before Top 3 how we get to know the position

@Leo-qo5hk 3 ай бұрын

Hello Ankit could you please share the script for this queries

@AbhishekKumar-gf4db 3 ай бұрын

Thanks #ankit sir, for this important video. Please 🙏 create a separate video for how to deal with HR,when she asks why you want to leave your job now,you have only 1 year experience.

@bhuwneshchaudhary6149 Ай бұрын

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

@ankitbansal6 Ай бұрын

Select -> order by -> top 2

@yashwanthgaming137 3 ай бұрын

Que: In a month vendor is null then replace with previous month vendors. Input: Year | Vendor | Amt 1-2021 | A | 100 1-2021 | B | 200 1-2021 | C | 300 2-2021 | Null | Null 3-2021 | A1 | 210 3-2021 | B1 | 230 4-2021 | Null | Null output: Year | Vendor | Amt 1-2021 | A | 100 1-2021 | B | 200 1-2021 | C | 300 2-2021 | A | 100 2-2021 | B | 200 2-2021 | C | 300 3-2021 | A1 | 210 3-2021 | B1 | 230 4-2021 | A1 | 210 4-2021 | B1 | 230 How to solve this question Ankit Sir

@user-dw4zx2rn9v 3 ай бұрын

with cte as ( select * , lag(grp) over (order by date) as prev_grp from (select date, group_concat(vendor) as grp from sales group by date) as x ) , cte2 as (select date, grp from cte union all select date, prev_grp as grp from cte ) ,cte3 as ( select * from cte2 where grp is not null ) SELECT date, SUBSTRING_INDEX(SUBSTRING_INDEX(grp, ',', n), ',', -1) AS grp FROM cte3 CROSS JOIN (SELECT 1 AS n UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) AS numbers WHERE n

@maqbul313 3 ай бұрын

Please provide employee and orders table scripts for download. Thank you

@UshaNirmal-we6ct Ай бұрын

Hi ankit can you make sql 100 practical questions to lifetime access instead of 1 year Please do that I am about to buy that course

@zuhebkhan6973 2 ай бұрын

Hi Ankit Bhai I love your work and I have learnt lot from ur videos as from non IT background I have learnt lot from ur end and started giving interviews for IT sector Today I had interview and they had asked one question on sql Like we have a table with row as string Table1 A B C now they need output as Abc Bac Cab Bac like wise plse help me making this video it will great help to me and other like me

@ankitbansal6 2 ай бұрын

What's the logic here .?

@zuhebkhan6973 2 ай бұрын

Even I'm clue less they ask me to get column as crossponding each letter

@anchal7876 3 ай бұрын

where i can find syntax?

@jaychavan119 3 ай бұрын

Please provide the Database

@sravankumar1767 2 ай бұрын

Can you please take one scenario and explain using where & And condition output results for each joins

@ankitbansal6 2 ай бұрын

Check this out kzfaq.info/get/bejne/j9anmdRm2bTbXWg.html

@pranaykukadkar7092 2 ай бұрын

@ankitbansal6 Please provide the sample data for order table for practise purpose. Thank you

@krishnatripathi5461 Ай бұрын

Share the dataset please

@indiebadger5225 3 ай бұрын

Hello Ankit, which screen recording application do you use? And if I am on a call with some, will the recording take their sound as well. Thanks

@ankitbansal6 3 ай бұрын

I use chrome extension for screen recording

@sandeepanand3834 Сағат бұрын

dataset please, to practise

@abhinav8160 21 күн бұрын

sir plse share this data set

@vishalsonawane.8905 2 ай бұрын

@ankitbansal6 Sir content is incomplete until u can not provide your dataset link in description in video :)

@anand.maheshwari 3 ай бұрын

Kindly tell us where would I found the data you used.

@usharanikallubhavi7466 2 ай бұрын

at around 16:50 time of the video, NULL has been replaced by sales. So, we have got the same value in row1 for both sales and previuos_year_sales columns. But, logically speaking there’s no year previous to 2018, so the previous_year_sales should have been 0, isn’t it. Please clarify. Thanks.

@ankitbansal6 2 ай бұрын

If we consider it has 0 then growth will be very high. The same means no growth as the company just started .

@usharanikallubhavi7466 2 ай бұрын

@@ankitbansal6 Appreciate the quick response.