Solve SQL Interview Questions for Data Analyst - Product Based Company Job Interview

No video

Solve SQL Interview Questions for Data Analyst - Product Based Company Job Interview

Рет қаралды 100,406

Күн бұрын

Solve SQL Interview Questions for Data Analyst - Product Based Company Job Interview
Hi folks, this question is asked many times by the product based companies for data analyst job role.
🔖Download SQL Interview Q&A PDF: bit.ly/3M7YHxJ
👍Subscribe Now: bit.ly/3Fc7Gc6
👉Instagram: / rishabhnmishra
➖➖➖➖➖➖➖➖➖➖➖➖➖
Q1: Create match table:
CREATE TABLE match ( team varchar(20) )
INSERT INTO match (team) VALUES ('India'), ('Pak'), ('Aus'), ('Eng')
Q2: Create emp table:
CREATE TABLE emp ( ID int, NAME varchar(10) )
INSERT INTO emp (ID, NAME)
VALUES (1,'Emp1'), (2,'Emp2'), (3,'Emp3'), (4,'Emp4'),
(5,'Emp5'), (6,'Emp6'), (7,'Emp7'), (8,'Emp8')
➖➖➖➖➖➖➖➖➖➖➖➖➖
More SQL for data science Videos:
📢Full SQL Tutorial in One Video: • SQL Tutorial for Begin...
🔖 Top SQL Interview Questions and Answers: • Top SQL interview Ques...
🔖Most Asked SQL Interview Question: • Most Asked SQL Intervi...
🔖SQL Tutorial Playlist: • SQL Tutorial In Hindi
➖➖➖➖➖➖➖➖➖➖➖➖➖
📣Want to connect with me? Check out these links:📣
👉Instagram: / rishabhnmishra
👉LinkedIn: / rishabhnmishra
👉Twitter: / rishabhnmishra
➖➖➖➖➖➖➖➖➖➖➖➖➖
More Related Videos:
📢Full Excel Tutorial in one Video: • Excel Tutorial For Beg...
🔖Excel Tutorial Playlist: • Excel for Beginners | ...
🔖Complete Data Analyst Roadmap: • How to Become Data Ana...
🔖Data Analyst Roadmap, Skills and Jobs: • Data Analyst- Skills, ...
🔖What Does a Data Analyst Actually Do?: • What Does a Data Analy...
➖➖➖➖➖➖➖➖➖➖➖➖➖
Hope you liked this video and learned something new :)
See you in next video, until then Bye-Bye!
Pls ignore
SQL Interview Question
SQL Interview Questions and Answers
SQL Interview Questions
Sql interview query
advance sql query
sql for data analyst
sql question query
SQL Interview Questions Answers
Mostly asked SQL Interview Questions Answer
Commonly asked SQL Interview Questions Answer
SQL Command Based Interview Questions Answer
Advanced SQL Interview Questions Answer
Top 10 SQL Interview Questions Answer
SQL Interview Questions SQL Interview Questions and answers for Freshers and Experienced
Top 10 SQL Interview Questions Answer
SQL Interview Questions Answer
SQL Interview
SQL Interview Questions for freshers
SQL Interview Questions and answers for freshers
SQL Roadmap
SQL Interview Questions 2023
SQL Interview Experience Interview questions for SQL Experienced

Пікірлер: 150

@amitgajkal4821 2 ай бұрын

Round robin calculation (number of matches played without any repetition) = n*(n-1)/2 select a.team team_A, b.team team_B from match a join match b on a.team b.team where a.team < b.team order by team_A above also give same output without using CTE and window function.

@hassamulhaq7762 Жыл бұрын

I figure out here I need a self-join, windows function, and where clause to solve this query, but I didn't know about CTE. Thanks for such tutorials.

@susamay Жыл бұрын

Please keep going like this. Don't loose motivation if these videos doesn't get reach immediately, eventually someone like me will discover your channel in near future and keep coming to your channel for all the videos. Just keep at it

@RishabhMishraOfficial Жыл бұрын

Thank you for your kind words 👍

@SN-ec1xi 4 ай бұрын

@@RishabhMishraOfficial please post more videos of QnA and more project videos .. Also please let us know how to escape the boredom while preparing

@neenanazar5637 Жыл бұрын

Hi Sir..was waiting for this video..completed full sql course ,sql portfolio watching your channel.created my portfolio and uploaded full script in github

@RishabhMishraOfficial Жыл бұрын

Awesome.. all the very best brother 👍

@ashishsrivastav11111 Жыл бұрын

Phle row number daal diya..order by asc in over clause....stored in cte table...than magic happens with self join....where a. Id b.id and a.id < b.id❤

@architaroy660 Жыл бұрын

Waiting for part 3

@Ankurkumar-yt4oo Жыл бұрын

Looking to build up connection as a data analyst aspirant ..

@user-wu5zo1th5o 9 ай бұрын

u done a very good and helpful job bhai. we need like u more skilled people to India. Thanks

@rishav144 Жыл бұрын

Thanks bro ...Ek End to End Python Data Analysis project lao pls

@RishabhMishraOfficial Жыл бұрын

Will upload soon

@rithikahuja8203 Жыл бұрын

Reallt helpful Rishab bhaiya keep going ❤❤

@zeeshanraza1393 Жыл бұрын

Rishab Bhaiya plz plz plz next video Data Analyst Interview Preparation Plus Preparation Resources Prr Bnao jesy app nyy Data Analyst Road Map Plus Unky Resources prr bnai the

@inshortview Жыл бұрын

Learning in own pace Thankyou Bhaiya

@swapnilpalsapure9781 2 ай бұрын

Very well explained

@sushantmeshram5172 2 ай бұрын

thank you so much Rishab!

@shreekantgosavi4726 Жыл бұрын

This is really Helpful

@saumyajoshi-ym2os Жыл бұрын

Sir leetcode SQL questions enough for product based company? And please make a roadmap for data analyst preparation and resources product based company Bcoz you are genius except few people like you rest of the channels guide to learn DSA specially when you work on technology after the interview but in data analyst we do the sem work what we prepare for interview

@RishabhMishraOfficial Жыл бұрын

Do leetcode questions n work on good industry level projects. For data analyst roles we don't need DSA as a freshers

@saumyajoshi-ym2os Жыл бұрын

@@RishabhMishraOfficialplease share your experience about the practical work challenges as a fresher after getting the data analyst job and what kind of training you got and the client expectations you know bcoz mass recruiters hires in bulk then they train in different technologies and project in different technologies and so on

@anandgaurav-om9ot Жыл бұрын

Thanku sir for clear Understanding 🙏

@RishabhMishraOfficial Жыл бұрын

Glad it was helpful ✅️

@saianshvlogs6452 Жыл бұрын

main khudd data analyst hun but kaffi sari chize hai jo abhi mujhe nhi pta hai to me ye samjh paa rhi hun ki kai logo ko isme bhi problem hoti hai ki resum me kyq kya update kre or project details me kya likhe job kaise milegi

@shubhvivekphotography1658 7 ай бұрын

Kitna tym lagta hai 3no ko seekhne mej

@ChotyaBhava 6 ай бұрын

Aapka.no.do plzz😢😢 bhaiya

@sadiqpatel3491 22 күн бұрын

Matches Ke Liye Simple trcik hai Total Teams * (Teams - 1)/2

@pushpendrakumar417 Жыл бұрын

HI RISHABH YOUR TECHING METHOD IS AWESOME THEN OTHERS I WANT TO LEARN FULL AZURE DATA ENGINEER COURSE PLEASE SUGGEST ME , WILL YOU PROVIDE ONLINE FOR THE SAME.

@HarshitJain-mc8gn Жыл бұрын

One more solutions using 3 CTE's. Little complex than the smarter solution u mentioned. WITH CTE AS ( SELECT A.NAME AS TEAM1, B.NAME AS TEAM2 FROM TEAMS AS A CROSS JOIN TEAMS AS B ), CTE_2 AS ( SELECT * FROM CTE WHERE TEAM1 TEAM2 ), CTE_3 AS ( SELECT GREATEST(TEAM1, TEAM2) AS FIRST, LEAST(TEAM1, TEAM2) AS SECOND FROM CTE_2 ) SELECT DISTINCT * FROM CTE_3 ORDER BY SECOND;

@RishabhMishraOfficial Жыл бұрын

If it works it good 👍

@emu9991 10 ай бұрын

bahi itna complex likhoge to khud hi phas jaaoge....keep code as simple as possible.......

@realfacts3517 Жыл бұрын

Thank you Sir!

@de_vasu Жыл бұрын

Please do continue this session learned a lot

@RishabhMishraOfficial Жыл бұрын

Sure, glad it was helpful ✅️

@gkapadi9831 2 ай бұрын

Select a.team as team_A,b.team as team_b from match a,match b where a.team>b.team and a.teamb.team

@zeeshanraza1393 Жыл бұрын

Rishabb Bhai Plzzzzzzzzzzzzzzzzzzzzzzzz Next Video Data Analyst Preparation Plus Resources Prr anii chayee tk hum easily koi be Company Crack Kr Payen

@Tradeholic_Zone Жыл бұрын

thank you sir❣ looking for more videos

@akashgoel601 Ай бұрын

I have not used the functions you suggested but still getting similar output.. hope this approach is ok.. thanks! with cte as (select ID,CONCAT(ID,' ',Name) as out from emp),cte2 as ( select CONCAT(c1.out,',',c2.out) as result, ROW_NUMBER() over (order by c1.ID) as groups from cte c1 join cte c2 on c1.ID+1=c2.ID) select result, groups from cte2 where groups%2!=0

@ishika7585 18 күн бұрын

select * from match a,match b where a.team

@tanishqtomar9786 Ай бұрын

sir 1st question m group by use nhi krskte they kya duplicate values hatane k liye ?

@niladribiswas7667 Жыл бұрын

Thank you sir for the vdo ❤

@user-oz2yz4wp8q Жыл бұрын

Nice informative videos!! Thank you :) Just a thought: your language and face reminds me Indian cricket captain Rohit Sharma :)

@bishtji-em2zt Жыл бұрын

Bhai aap great ho

@RishabhMishraOfficial Жыл бұрын

Glad you liked the video ✅️

@srushtiOm 2 ай бұрын

With cte as (Select *, lead(team,1) over (order by (select null)) as Tab_1 from match union select *, lead(team,2) over (order by (select null)) as Tab_1 from match union select *, lead(team,3) over (order by (select null)) as Tab_1 from match) Select * from cte where Tab_1 is not null Is this solution valid for Q1? The sequence is not the same. But results are more or less the same. Do let me know. Thanks!

@adityawasankar7929 Жыл бұрын

Rishabh bhai please make project video on Tableau

@RishabhMishraOfficial Жыл бұрын

Noted ✅️

@himanshurai7881 Жыл бұрын

Which one is most demanding for a job.? MySQL, MS SQL, postgresql

@RishabhMishraOfficial Жыл бұрын

MS sql, but it depends on job n company

@aasthasinghal9668 4 ай бұрын

Video is really helpful but the maths part in Q1 is not clear, it is confusing, we don't know why r =2 , it'd be great if you could explain that.

@googlechannel3664 11 ай бұрын

sir,mysql benchmark,it dont have string__agg function ,is there any option to solve

@vinitshirke7032 Жыл бұрын

Sir pls course on tableau u r sql course really helped pls 🙏 sir

@Tokyo_17 Жыл бұрын

can you please make a video on power query

@mysoresairam5750 Жыл бұрын

excellent content🤩

@RishabhMishraOfficial Жыл бұрын

Glad you liked it ✅️

@ranjeetsk4043 8 ай бұрын

Match question me oh join is not required, just use where conditions a. I'd less than b. I'd. That's more than Enough

@day2daylifethings Жыл бұрын

Sir....sql 2.5hr wala srt Kiya Hai abhi....your way of explanation is very nice.....but sir Kuchipudi doubts aaye toh kaise contact Krein aapko

@RishabhMishraOfficial Жыл бұрын

Pls msg on Instagram, link in video description

@anuandaarushow8300 Жыл бұрын

Hello sir. I m sanjita. From past few days I m following you and watching your videos. All your videos are amazing and covers all important topics. Do you provide any certificate so that we could add that in our resume for getting a good job. I m from non tech background but now I want to do data analytics course. I will be very thankful if you give me all the information. Thanks

@RishabhMishraOfficial Жыл бұрын

No i don't provide any certificates, only projects n basic skills to learn n practice data analytics skills

@DharmendraKumar-DS Жыл бұрын

I have a question, when you completed your sql for the first time, were you able to solve all these problems without any help??...because I have learned sql but sill get confused while solving these kind of problems.

@RishabhMishraOfficial Жыл бұрын

No.. i did practice first then i tried some advanced level questions. After that i was able to solve it 👍

@chandrashekharmishra9521 Жыл бұрын

सब कुछ सीखने के बाद सबसे बड़ी समस्या है, जॉब के लिए intervew/apply/ रेफरल प्राप्त करना,कैसे इंटरवेव के लिए अप्लाई करें।यदि कुछ इसका तरीका हो तो प्लीज बताइए

@RishabhMishraOfficial Жыл бұрын

Okayy, noted. Will make a video on this ✅️

@chandrashekharmishra9521 Жыл бұрын

@@RishabhMishraOfficial thnx for it and I will wait

@AshaSharma-sd4jb Жыл бұрын

Sir mere English Communication week hai To muje interview me Problem hoga kya Data analysis role ke leye

@RishabhMishraOfficial Жыл бұрын

Only basic English is required

@piyushgupta5044 Жыл бұрын

Sir, plz make the videos on solution of sql queries of leetcode

@RishabhMishraOfficial Жыл бұрын

Okayy noted

@sukritisachan5773 Жыл бұрын

In 1st table match one can we not include an extra column as a primary key?

@RishabhMishraOfficial Жыл бұрын

There can be 1 pri column in a table

@sourabhsingh4236 11 ай бұрын

In interviews, do we need to answers verbally or they give us system for answer.

@devashishdeshmukh2180 Жыл бұрын

Great content sir ! Apart from topic i have question for you why do you switch from digital marketing . Is not worth it . Can explain pro & cons of industry . & Lil bit future prospect of Digital marketing. As ai coming to the picture

@RishabhMishraOfficial Жыл бұрын

Okayy noted ✅️

@Freakouts_and_found_Insane Жыл бұрын

2 Query asked in interview- Other way of solving is Concate Both columns Then using Rownumber function get even and odd I'd from the table then union them

@basavannimattikatti5790 Жыл бұрын

Hi sir,i have completed data analyst course,i want to do projects..can you suggest ,how can we work on real time data and projects?

@hRvlogs921 Жыл бұрын

Hi Sir, please make a video about the projects to be included in our resume while applying for data analyst as a fresher.

@RishabhMishraOfficial Жыл бұрын

Noted ✅️

@ishikasingh8693 7 ай бұрын

Hello! I appreciate your work. I want to ask you one thing to learning or solving sql query how much maths needs to be required?

@shubhambhosale8467 11 ай бұрын

create for 30 days python challenge pdf with hackerrank problem will be very helpfull same as sql sheet

@RishabhMishraOfficial 11 ай бұрын

That's a nice suggestion, will work on it 👍

@harshpandya9046 Жыл бұрын

Sir ek video banai jis mai Business analyst wala ko kitna SQL aana chahiye please

@RishabhMishraOfficial Жыл бұрын

Noted ✅️

@harshpandya9046 Жыл бұрын

@@RishabhMishraOfficial Thank you Sir

@bhavinpadhiyar9829 6 ай бұрын

Thank you, Rishabh for this video!! It would be helpful if you provide sample interview questions for Python also!!

@RishabhMishraOfficial 6 ай бұрын

Okayy noted ✅️

@poojasonavane Жыл бұрын

Is this necessary to learn to be a business analystics ??

@RishabhMishraOfficial Жыл бұрын

Yes, it helps to understand data better

@utkarshgarg7342 Жыл бұрын

Sir I want to ssis aur ssms mai kya difference hai aur data analyst bane ke liye ana chahiye

@STATUSSHUBHAM 4 ай бұрын

Aap apna khud ka data analytics course karate hai kya bhaiya mujhe sikhna hai data analytics aapse live batch hai kya

@susheelkharat5122 Жыл бұрын

Sir could please tell me that, excel's which vba macros are used for data analytics

@RishabhMishraOfficial Жыл бұрын

Check the data analyst roadmap video, hv shared all the details there along with free resources

@susheelkharat5122 Жыл бұрын

@@RishabhMishraOfficial Thanks brother, watched full video of roadmap and I got full knowledge of it. I will implement it.

@funvideoscorner 5 ай бұрын

Rishabh Mishra There is a error in your database file its not working

@Alex_499 Жыл бұрын

i have an interview today for sql developer but i dont have practical knowledge about complex queries .'😢 should i go for interview or not

@RishabhMishraOfficial Жыл бұрын

Yes, never miss any interview. It gives you a job or learning

@dearhraman Жыл бұрын

Šir į have one question Path learning python for data analytics

@saianshvlogs6452 Жыл бұрын

aap data analyst students ki itni help kr rhe but aap ek or help kriye sabhi data analyst ki LinkedIn me data analyst valo ko kya kya update kre ko vo job ke liye select ho or resume me bhi kya kya update kre kyu ki abhi tk ini details me koi bhi nhi bataya hai aap batao or video bhi banao

@RishabhMishraOfficial Жыл бұрын

Okayy noted ✅️

@itxrocky4566 2 ай бұрын

is it Last video of this series??

@jatinsinghtomar4027 Жыл бұрын

Sir I m cllg student so aap bata skte h data analyst me salary zada h ya Java backend me salary zada h or konsa sikhna chahiye

@senseimemes679 Ай бұрын

Sir how can I showcase my SQL project or make a presentation of my SQL project it's very confusing someone please help

@IshwarAcademy Ай бұрын

I have a solution for your query. Here is the Real-time SQL Project: kzfaq.info/get/bejne/kLNhi9N0v5aqlH0.html To know how to showcase SQL Project, Subscribe to my channel. In upcoming week, I will be posting a video related to the same, where you can understand how to showcase your project on Resume too.

@jagveersingh8458 Жыл бұрын

Please launch a course on sql

@RishabhMishraOfficial Жыл бұрын

Already uploaded

@jagveersingh8458 Жыл бұрын

@@RishabhMishraOfficial sir python project for data analyst

@RishabhMishraOfficial Жыл бұрын

Coming soon 🚀

@kunalkalal494 Жыл бұрын

Hello rishab sir Plz help how to use TCL .type means commit & save point in SQL server Plz sir

@pm-kj9lv Жыл бұрын

I started sql with theory I want to know how to practice it .plz let me know

@Zain.263 Жыл бұрын

Bhai if someone has less understanding of maths concepts , can he/she do data analyst job ?

@RishabhMishraOfficial Жыл бұрын

Yess

@analyst_adithya Жыл бұрын

they can do the job.. having that strong logic definitely helps to pick up new concepts more quickly

@paressh Жыл бұрын

Voice is enough.

@anuragpant2632 Жыл бұрын

Help to build portfolio how to add sal project on portfolio plz tel

@aparupmukherjee4954 Жыл бұрын

Do you provide any courses for power BI ?

@RishabhMishraOfficial Жыл бұрын

Yes it's on this youtube channel

@shubhampardeshi2873 Жыл бұрын

Sir data science ka course krke job mill skti hai na...diploma basis pr

@RishabhMishraOfficial Жыл бұрын

Yess

@SachinSingh9616 10 ай бұрын

Mat kr bhai

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

How is it r= 2 ?

@bushrasafi1966 9 ай бұрын

Hello sir I want to take admission of database administrator, for sql does my math needs to be good or math is not required??

@gauravverma7985 Жыл бұрын

Hi rishabh I'm beginner in power Bi can you please help i installed it but in the right side of sheet visualization panel is not showing also the other panels like data only filter thing appears can you tell how to fix it? Pleaseeee helpppppp

@addicted4253 Жыл бұрын

Is this for Freshers?

@RishabhMishraOfficial Жыл бұрын

Yess

@neetufabiyani9137 Жыл бұрын

why is r=2? can u please explain me

@RishabhMishraOfficial Жыл бұрын

Already explained in the video 🤦‍♂️ n = 4 bcoz we have 4 teams And r = 2 bcoz there will be a match btw 2 teams

@neetufabiyani9137 Жыл бұрын

@@RishabhMishraOfficial thanks

@unfortunately_but_engineer9207 10 ай бұрын

For 2nd question we can also use this soln: select CONCAT(id_name,',',lead)as Result, row_number() over (order by id) as groups from (select *, lead(id_name,1) over (order by id)as lead from(Select *,CONCAT(id,' ',name)as id_name from employee) a)b where id%2 0

@InnovationInflux 3 ай бұрын

Can also use the below when you dont know the number of rows. '''Lead is used the get the next row''' WITH CTE_Temp AS ( SELECT employee_id, name, LEAD(employee_id) OVER (ORDER BY employee_id) AS next_id, LEAD(name) OVER (ORDER BY employee_id) AS next_name FROM employee ) Select employee_id, CONCAT(employee_id,', ', name,', ', next_id,', ', next_name) from CTE_Temp where next_name IS NOT NULL

@RishabhMishraOfficial 3 ай бұрын

If the output matches then yess you can use it

@punjabifashionworld Жыл бұрын

Data analytics mein job k liye apply kon kon kr skta hai sir reply jrur karna?

@RishabhMishraOfficial Жыл бұрын

Koi bhi, bus skills aur projects aata ho

@punjabifashionworld Жыл бұрын

@@RishabhMishraOfficial ok thanks a lot Apki video se krege tyaar

@optiongreeks_265 11 ай бұрын

On serious note you need to speak slow really difficult to understand to a person like me whose understanding compiler runs slow

@RishabhMishraOfficial 11 ай бұрын

Okayy noted ✅️

@sipunkumar9578 Жыл бұрын

Sir data analyst ke liye konsa chahiye btech me •computer science engineering •computer science AI •computer science engineering and artificial intelligence •computer science engineering and data science

@RishabhMishraOfficial Жыл бұрын

Koi bhi branch se karlo but skills are important aur vo tumko apne aap se sikhna hoga

@axardave5775 Жыл бұрын

bro would you like to train me by online classes?

@SachinSingh9616 10 ай бұрын

There is no job for freshers in market

@paressh Жыл бұрын

One request just hide yourself.

@nikhil4062 11 ай бұрын

WITH cte_new AS ( Select *,ROW_NUMBER() OVER(ORDER BY team ASC) from matches ) I am trying this query for cte but it is giving me error in my sql , can anyone tell why so?

@arpiteshsrivastava9838 8 ай бұрын

Note - In MySQL STRING_AGG is not supported. Alternative is to use GROUP_CONCAT. with cte as (select *, concat(id, ' ', name) as con, ntile(4) over(order by id) as rn from emp_1) select group_concat(con separator ', ') as result, rn as 'groups' from cte group by rn; Thanks Rishabh.