Query 3: Complex JOINS and SUBQUERIES | Solving TRICKY SQL Interview Queries #sqlinterviewquestions

Hi, In this video we've discussed a tricky SQL Interview Question. This is a 5 days series where I will solve SQL Interview questions. I would highly recommend watching all the videos from this series if you want to master SQL (SQL Query Interview Questions)
#sql #sqlinterviewquestionsandanswers #sqlinterview
✨Link to all the videos in this series can be found in this playlist:
kzbin.info/aero/PLtPFQl_0853pmiE1cyZsGX7p5L-DytnyF&si=IFR0L8Ky8VF9rXVP
✨Link to my e-books:
▪️SQL e-book: imojo.in/rkajq9
▪️'Switch your career easily' e-book: imojo.in/1FL7KaG
(Perfect for anyone willing to switch to a completely new field or to a different company in the Tech World)
✨Join this channel to get access to perks:
kzbin.info/door/43CDA3m7Nwfdj8B9SAZQ4Ajoin
✨Work related mails can be sent on [e-mail]
✨If you appreciate my work and would like to donate to support our channel, you can do so here : paypal.me/sadia1702
✨Please like, share, subscribe and comment down. It would make my day :)
Thank you, have a nice day!

[@gnanatejserla6388]

Thankyou

[@kst4269]

thank you,,

[@tradingtrade9836]

Can you please provide this tables for practice

[@budhahemalatha6440]

Hello mam.If I created a table with 3 columns and insert into the table.after I have added another columns salary using alter.Is it possible to insert all salary at a time..

[@samtej3130]

is there any way where I can get you notes from u r end?

[@devisunuwar202]

But the question is to show full name first name then space then last name so can we do using concat?

[@crackconcepts]

Yes you can 👍

[@petsloverscontent]

Transact sql or mysql ?