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

[@amitgajkal4821]

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.

[@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❤

[@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]

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

[@cinevibes1988]

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 👍

[@MahammedKareemulla]

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

[@rithikahuja8203]

Reallt helpful Rishab bhaiya keep going ❤❤

[@architaroy660]

Waiting for part 3

[@Ankurkumar-yt4oo]

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

[@inshortview]

Learning in own pace Thankyou Bhaiya

[@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

[@rishav144]

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

[@RishabhMishraOfficial]

Will upload soon

[@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]

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

[@shreekantgosavi4726]

This is really Helpful

[@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

[@anandgaurav-om9ot]

Thanku sir for clear Understanding 🙏

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@swapnilpalsapure9781]

Very well explained

[@realfacts3517]

Thank you Sir!

[@gkapadi9831]

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

[@sushantmeshram5172]

thank you so much Rishab!

[@zeeshanraza1393]

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

[@Delhi_Trader01]

thank you sir❣ looking for more videos

[@VISHALKUMAR-xc6kt]

Easy solution using cte ❤

[@RishabhMishraOfficial]

💯

[@de_vasu]

Please do continue this session learned a lot

[@RishabhMishraOfficial]

Sure, glad it was helpful ✅️

[@bishtji-em2zt]

Bhai aap great ho

[@RishabhMishraOfficial]

Glad you liked the video ✅️

[@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

[@SmitaThakre-o7q]

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

[@niladribiswas7667]

Thank you sir for the vdo ❤

[@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.

[@mysoresairam5750]

excellent content🤩

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@ranjeetsk4043]

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

[@vinitshirke7032]

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

[@adityawasankar7929]

Rishabh bhai please make project video on Tableau

[@RishabhMishraOfficial]

Noted ✅️

[@Pie_suchi]

can you please make a video on power query

[@piyushgupta5044]

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

[@RishabhMishraOfficial]

Okayy noted

[@shubhambhosale8467]

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

[@RishabhMishraOfficial]

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

[@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

[@tanishqtomar9786]

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

[@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]

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?

[@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

[@harshpandya9046]

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

[@RishabhMishraOfficial]

Noted ✅️

[@harshpandya9046]

@@RishabhMishraOfficial Thank you Sir

[@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

[@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 ✅️

[@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

[@sourabhsingh4236]

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

[@Herfggjghtdh]

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

[@himanshurai7881]

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

[@RishabhMishraOfficial]

MS sql, but it depends on job n company

[@googlechannel3664]

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

[@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.

[@chandrashekharmishra9521]

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

[@RishabhMishraOfficial]

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

[@chandrashekharmishra9521]

@@RishabhMishraOfficial thnx for it and I will wait

[@utkarshgarg7342]

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

[@aasthasinghal9668]

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.

[@bhavinpadhiyar9829]

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

[@RishabhMishraOfficial]

Okayy noted ✅️

[@srushtiOm]

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!

[@AmanAnalytic]

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

[@paressh]

Voice is enough.

[@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 👍

[@jagveersingh8458]

Please launch a course on sql

[@RishabhMishraOfficial]

Already uploaded

[@jagveersingh8458]

@@RishabhMishraOfficial sir python project for data analyst

[@RishabhMishraOfficial]

Coming soon 🚀

[@ishika7585]

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

[@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?

[@kunalkalal494]

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

[@anuragpant2632]

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

[@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

[@aparupmukherjee4954]

Do you provide any courses for power BI ?

[@RishabhMishraOfficial]

Yes it's on this youtube channel

[@poojasonavane]

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

[@RishabhMishraOfficial]

Yes, it helps to understand data better

[@STATUSSHUBHAM]

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

[@pm-kj9lv]

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

[@shubhampardeshi2873]

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

[@RishabhMishraOfficial]

Yess

[@SachinSingh9616]

Mat kr bhai

[@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

[@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

[@funvideoscorner]

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

[@simrankhushwani8552]

Hi Rishabh ,are these questions asked in fresher interview or for experienced SQL people .Please let me know so that I can prepare accordingly

[@RishabhMishraOfficial]

Mostly experienced

[@itxrocky4566]

is it Last video of this series??

[@bushrasafi1966]

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

[@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

[@vishalsonawane.8905]

How is it r= 2 ?

[@KHANDAUD679]

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: kzbin.info/www/bejne/kH6UiaN5j5V5mqs 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.

[@HARSHRAJ-gp6ve]

with cte as( select emp.*,LEAD(ID)OVER() as id1,LEAD(NAME)OVER() AS name1,ROW_NUMBER()OVER() as x3 FROM emp ),cte1 as( select x3,CONCAT(ID,NAME) as x1,CONCAT(id1,name1) as x2 FROM cte where x3%2!=0 ) select CONCAT(x1,',',x2) as group1,ROW_NUMBER()OVER() as x4 FROM cte1;

[@RishabhMishraOfficial]

Awesome, keep learning n keep growing 🚀

[@addicted4253]

Is this for Freshers?

[@RishabhMishraOfficial]

Yess

[@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

[@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

[@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

[@purumallasathvik1766]

what is the solution in mysql

[@belalahmad3980]

Sir MySQL me string_agg() function nhi kaam kar Raha hai

[@akhandpratapgupta8232]

MySql Solution code for Q2: with cte as( select *, concat(Id,' ',name) as GrpName, ntile(4) over(order by Id asc) as GrpId from emp) select group_concat(Grpname separator ', ') as Result, GrpId from cte group by GrpId order by GrpId;

[@InnovationInflux]

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]

If the output matches then yess you can use it

[@Divyascorporatediary]

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

[@axardave5775]

bro would you like to train me by online classes?

[@optiongreeks_265]

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

[@RishabhMishraOfficial]

Okayy noted ✅️

[@SachinSingh9616]

There is no job for freshers in market

[@paressh]

One request just hide yourself.

[@nikhil4062]

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?

[@SakshiiiRathod]

I used Cross join for Q1, ----> Select M1.team as T1, M2.team as T2 from Match M1 Cross join Match M2 where M1.team != M2.team and m1.team < m2.team

[@arpiteshsrivastava9838]

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.

[@satyamdashora2489]

[@roc9999]

plz note I am learning sql and not champ this is my solution for both problems: with my_teamA as ( select team as team_A, row_number() over(order by team asc) as rowno from match), my_teamB as( select team as team_B, row_number() over(order by team asc) as rowno from match) select t1.team_A, t2.team_B from my_teamA as t1 join my_teamB as t2 on t1.team_A!=t2.team_B and t2.team_B!=t1.team_A and t2.team_B>t1.team_A order by 1,2 and with cte as (select concat(id, ' ', name) AS concat_a, row_number() over() as rowno from emp where mod(id, 2) 0), cteb as (SELECT concat(id, ' ', name) AS concat_b, row_number() over() as rowno FROM emp where mod(id, 2) = 0) select concat(a.concat_a,',',b.concat_b) as output, row_number() over() as rowno from cte a join cteb b on a.concat_ab.concat_b where a.concat_a=b.rowno

[@RishabhMishraOfficial]

If you're getting same results then it correct 👍👍

[@chakeriancrew9189]

Bro how can I contact you i wannt advice from you

[@RishabhMishraOfficial]

Pls msg on Instagram or LinkedIn, links in video description

[@knowledgeispower9662]

sir i messaged you on instagram but you didn't reply

[@RishabhMishraOfficial]

Pls tell me your account name on Instagram

[@comedy11260]

Waiting for part 3