I had an interview today and over the client call. they asked me write the query about "find the candidate with these skills" and I was lucky enough that I know this through your channel. Even though query did not work but they got the idea that I know this. I don't know if I will be selected or not but it definitely boost my confidence. Thanks a ton.
Literally one of the best channel related to data analyst/data science! Waiting for some more tutorials and projects related to this field. Also kindly continue this series on sql interview questions as this is by far the most asked thing in the interview
I was asked in recent interview for QA manual 1. Find the list of employees in which 2nd letter is 'A'. 2 Find the 2nd highest salary 3. Aggregate functions 4.Constraints in SQl
In question no. 11 As per my understanding we can't use equal operator to compare NULL values because very NULL is different with other one that's why we have IS NULL, NOT NULL.
Yeah i think you're right 🤔 But you can use equals to Operator to update a value in sql. UPDATE customers SET C_CONTACTNO = NULL WHERE C_ID = 4; This works!
I found the education channel First Aisa Channel to be a good one which gives you the opportunity to learn everything in easy language. I learned a lot from here, that's why I share this channel once every day. Rishabh bhai thank you so much!
@Rishabh Mishra - in the question no 3, what if there is duplicate entry for skill sql instead of python, I mean for candidate id 101, if there are 3 entries of skills like SQL,POWER BI and SQL. The count will still show 3 but that is not the condition right ? how do we deal with duplicates skill entries ?
Hello Rishabh bhai, a small correction at 6:47 in Solution MySql: please select 'MONTHNAME' instead of 'MONTH' to get the name of month. Keep it up the nice work👍
19:03 SELECT * FROM table WHERE column = NULL; is incorrect in SQL syntax because NULL represents the absence of a value, and it cannot be compared using the equality operator (=)
For MySQL you can also use below query it will show month name also :-- SELECT YEAR (order_date) AS Years, MONTHNAME(order_date) AS Months, SUM(sales) AS TotalSales FROM Products GROUP BY YEAR(order_date), MONTHNAME(order_date) ORDER BY TotalSales;
If you are getting the same Error in Q2 you can also use For MySQL :-- SELECT YEAR(order_date) AS Years, MONTH(order_date) AS Months, SUM(sales) AS TotalSales FROM Products GROUP BY YEAR(order_date), MONTH(order_date) ORDER BY TotalSales;
Thanks a lot for such a wonderful sessions… just with 2 videos my most of the sql concepts are making sense now… thanks a lot 🎉🎉 And congratulations for your achievement😍🧿
Sir you have set a new milestone to the learners it's a blessing to found your channel and learn from it. I have completed your power BI three lectures and literally they are the best ❤❤❤❤❤
Your videos have been very helpful, and it would be great if you could provide more practice SQL questions in future videos. I appreciate the value of your content and find it worth watching
Really enjoying watching your videos, learning a lot , Thanks for doing such a great work for community. God bless you. A request - Could you please make a video on SQL server profiler and how to debug Stored Procedure??
If we use something to avoid duplicates in Q3, wouldn't it make more sense. Practically in a large database there are chances of duplication due to manual or technical errors.
Hey hope you doing good I am new here I feel you doing fantastic work your way of teaching unbelievable... I requested to you please make vedio on full analysis like how to collect data how to transform, organize data, and how make preidiction and drive informed decisions... And where I need sql and python and pythonlibraries for retrieves and manipulate data
Please more sql queation video share with data . Data rah to sath-sath pratice hoti hai . your video awsome hai voice video clearity👍. Muzhe bohat help ho rahil hai .
solution for question 3: SELECT candidate_id FROM your_table_name WHERE skills IN ('sql', 'python', 'power bi') GROUP BY candidate_id HAVING COUNT(DISTINCT skills) = 3 ORDER BY candidate_id ASC; Is thisone correct solution rishabh bro??
I had an interview today and over the client call. they asked me write the query about "find the candidate with these skills" and I was lucky enough that I know this through your channel. Even though query did not work but they got the idea that I know this. I don't know if I will be selected or not but it definitely boost my confidence. Thanks a ton.
Excellent! Keep learning n keep growing 🚀
in which company ? which types question will asked you?
Which other questions they asked
Idiot say which question and which company name what will be useful for us for sharing this without the actual questions rip society
Sir tumhi khup changl shikvta youtube vr best samjel as shikvnare tumhich ahat ❤
One of My best learning Channel..... Thanks for this video Sir... :)
Glad you liked the content ✅️
Hiiiii
Very Useful and explained very easily ....Waiting for Part 2 Interview Questions
Literally one of the best channel related to data analyst/data science! Waiting for some more tutorials and projects related to this field. Also kindly continue this series on sql interview questions as this is by far the most asked thing in the interview
More to come!
I was asked in recent interview for QA manual
1. Find the list of employees in which 2nd letter is 'A'.
2 Find the 2nd highest salary
3. Aggregate functions
4.Constraints in SQl
Bhai boht easy hai 4wo questions
for which company, deloitte?
@@bindusharma8625 Pinelabs
In question no. 11
As per my understanding we can't use equal operator to compare NULL values because very NULL is different with other one that's why we have IS NULL, NOT NULL.
Yeah i think you're right 🤔
But you can use equals to Operator to update a value in sql.
UPDATE customers
SET C_CONTACTNO = NULL
WHERE C_ID = 4;
This works!
Yes, for comparing Null values we don't use equal operators in sql.
We always use 'Col_name is Null'
true...we can't use equals to operator for comparing nulls...I got stuck at the same thing watching the video
Hi Rishabh, please suggest some most asked questions in Power Bi & Dax at the intermediate level. U can also share the questions only.
Indian paradise Trainer visit this channel
best channel for Data Science
Glad you think so ✨️
One of the best learning channel thank you very much sir
Glad you liked ✅️
all videos are amazing... also u provide a pdf that is very useful.. Thank you so much, sir.
Glad it was helpful ✅️
Really great channel. Your quality is at it's peak.
Very helpful! Thank you very much. Am literally watching this video one day before my interview
Glad it was helpful! ✅️
Sir, thanks for such videos which are very helpful for data aspirants
Glad you liked it ✨️
I found the education channel First Aisa Channel to be a good one which gives you the opportunity to learn everything in easy language. I learned a lot from here, that's why I share this channel once every day. Rishabh bhai thank you so much!
Glad you liked ✅️
Keep continue sir 😊🙏
Great content ❤️😍👌
Glad you liked it ✨️
Wow loved the way Rishab teaching SQL concepts enjoyed video.🤩
Nicely explained today learnt something new. Thank you Rishabh bhai🙌
@Rishabh Mishra - in the question no 3, what if there is duplicate entry for skill sql instead of python, I mean for candidate id 101, if there are 3 entries of skills like SQL,POWER BI and SQL. The count will still show 3 but that is not the condition right ? how do we deal with duplicates skill entries ?
In that case you can take distinct of skills as CTE n rest of the steps will be same n you will get the answer. Btw good question brother ✅️
Thanks a lot sir.... such valuable information
Thanks bro..very helpful.. best of luck for channel.. learning more from you..
Your Content is always nextLevel
Thankyou sir.
The way you provided code even for creating the input table,hats off sir
Glad it's helpful ✅️
Hello Rishabh bhai, a small correction at 6:47 in Solution MySql: please select 'MONTHNAME' instead of 'MONTH' to get the name of month.
Keep it up the nice work👍
Ok. Thanks 👍
19:03
SELECT * FROM table WHERE column = NULL; is incorrect in SQL syntax because NULL represents the absence of a value, and it cannot be compared using the equality operator (=)
from-> join-> on-> where-> group by-> having-> select-> order by -> limit
Very well explained. Thanks a ton!!!!
Glad it was helpful ✅️
Well explained 🥳
👍
For MySQL you can also use below query it will show month name also :--
SELECT YEAR (order_date) AS Years, MONTHNAME(order_date) AS Months, SUM(sales) AS TotalSales FROM Products GROUP BY YEAR(order_date), MONTHNAME(order_date) ORDER BY TotalSales;
Error-----'MONTHNAME' is not a recognized built-in function name.
If you are getting the same Error in Q2 you can also use For MySQL :--
SELECT YEAR(order_date) AS Years, MONTH(order_date) AS Months,
SUM(sales) AS TotalSales
FROM Products
GROUP BY YEAR(order_date), MONTH(order_date)
ORDER BY TotalSales;
Thanks a lot for such a wonderful sessions… just with 2 videos my most of the sql concepts are making sense now… thanks a lot 🎉🎉 And congratulations for your achievement😍🧿
Glad it was helpful! ✅️
Sir you are explaining very well. Thank you
Glad you liked ✅️
Sir you have set a new milestone to the learners it's a blessing to found your channel and learn from it.
I have completed your power BI three lectures and literally they are the best ❤❤❤❤❤
Glad it was helpful ✅️ keep learning n keep growing 🚀
Appka gane ka program kesa chal raha he
The way you explain the things its amazing thanks Rishabh
Glad you liked ✅️
Ans 1 select from where group by having order by limit
Thank You Rishabh great video 👏
Glad you liked it ✅️
Reviewing it again before going for an Interview,
Thankyou Rishabh bhaiya ❤❤
All the very best brother 👍
How was your Interview gone, bro? 🙄
Thank you so much sir for a sharing video
Glad you liked ✅️
Kindly continue this series on Important Questions on SQL
Coming soon ✅️
Execellent presentation Respected Sir
Glad it was helpful ✅️
Hi sir, Please make more videos on scenario based questions. Your explaination to queries are great. Please make more such content in postgresql.
Thank you sir , really valuable questions for us.
Please upload a video on Tableau project.
very very helpfull for me sir🙏❤
Glad you liked it ✨️
Sahab u r king 👑 of SQL plz post many sql video's
Glad you liked it ✅️
Your videos have been very helpful, and it would be great if you could provide more practice SQL questions in future videos. I appreciate the value of your content and find it worth watching
Noted.. will do ✅️
Sir msc mathematics can become python data analyst
Very informative video in simple way … 👍
Glad it was helpful! ✅️
very nice vdo and explaining sooo well
Glad you liked ✅️
Really enjoying watching your videos, learning a lot , Thanks for doing such a great work for community. God bless you.
A request - Could you please make a video on SQL server profiler and how to debug Stored Procedure??
Glad you liked ✅️ n noted ✅️
Solution of Question 3
select id,count(skills) as 'coreskills'
from [table_name]
group by id
having count(skills)=3
order by id
you are very hardworking, genius. you have put lots of efforts to make this videos. I CAN understand. thank you so much
Sir best video 📸
Sir thank uh so much for providing such a usefull and effective content!! So can uh pls make video on full fledge SQL project!?
You contain some special talent for explanation
meri galt fehmi the ki jayda subscriber waala
hi acha sikha hai . Thanks for this type of content.
Glad you liked it ✨️
Thanks for PDF ❤
Glad you liked it ✅️
I think this is easy compare to you for skills>3
Select candidate_id,count(*) from tablename group by candidate_id having count(*)>2;
thankyou bhaiya 😃😃😃
Glad you liked ✅️
Very informative video
Glad you liked it ✨️
thankyou sir for putting this effort for us
Glad you liked it ✅️
please more more parts of such amazing videos.
will be helpful
Okayy noted ✅️
Keep up the good work
I find your videos really helpful.
Thanks for this Content ❤.
Glad you liked ✅️
Please make video on MySQL for data analytics
If we use something to avoid duplicates in Q3, wouldn't it make more sense. Practically in a large database there are chances of duplication due to manual or technical errors.
Keep it up sir 👍 very helpful content 😊
Greattttttt!
Bhaiya please make videos on cte and regex also please
Glad you liked it ✅️ n noted ✅️
Useful video sir
Glad you liked it ✅️
How to find duplicate data without using group by clause and distinct ? Using CTE
thank you so much Rishab
Excellent videos Mishra ji. Aise video dekhe nahi kabhi
Glad you liked ✅️
valuable content brother ...and congratulations brother u marked 120k subs. keep growing
Glad you liked it ✅️ n thank you so much brother 🙌
please keep uploading bhaiya. Nice content
More videos coming soon
Really HatsOff to your HardWork bro
Glad you liked ✅️
Thank you soo much 🎉
Helpfull...👍
Glad it helped ✅️
Good content
Q14 : do we have to specify conditions to update ? If yes there is no condition mentioned
Thank you sir ❤❤
Rishabh, please upload a detailed video on SQL triggers
Hey hope you doing good I am new here
I feel you doing fantastic work your way of teaching unbelievable... I requested to you please make vedio on full analysis like how to collect data how to transform, organize data, and how make preidiction and drive informed decisions... And where I need sql and python and pythonlibraries for retrieves and manipulate data
Noted ✅️
Nice content. Please share create and Insert statements in the description box. Thank you.
Insert into tablename
Values ();
thanks sir for making this video
Glad you liked ✅️
please make more videos like this also please make a oneshot video on mysql
You explained very well sir I m waiting for another video
Sir I'm using Microsoft SQL server. What's the function i use instead of EXTRACT ? Please tell if u feel to answer 🙂
use year() and month() function to extract year and month from date
DATENAME(month, ‘08/09/024’)
DATENAME(month, ‘08/09/024’)
Please more sql queation video share with data .
Data rah to sath-sath pratice hoti hai .
your video awsome hai voice video clearity👍. Muzhe bohat help ho rahil hai .
Hi, excellent content. Can't we write extract (month from order date) to retrieve month?
Glad you liked it ✅️
Yes you can but all of this depends on which database u are working on.
@@RishabhMishraOfficial Thank you so much for your prompt response.
Rishabh please make video on Most common Data Analyst interview questions!
Noted ✅️
Mishra Ji Rocks 💥💥💥💥💥
By the way Mishra Ji You are From Where?
awaited for......complete data science project where excel ,sql,python & tableu used. @Rishabh Mishra
Okayy noted ✅️
Hi bhaiya
please try to bring atleast 1 project video every week . The viewers demand :)
Okayy noted ✅️, even i m thinking something similar to this
Aur videos Q/A pe post kariye , it's really helpful
Already uploaded one more video watch that it had advance questions as well
solution for question 3:
SELECT candidate_id
FROM your_table_name
WHERE skills IN ('sql', 'python', 'power bi')
GROUP BY candidate_id
HAVING COUNT(DISTINCT skills) = 3
ORDER BY candidate_id ASC;
Is thisone correct solution rishabh bro??
solution shi h but output table m skill count bhi chahiye to vo bhi select karna hoga
@@AditiSharma-zo5dq Please reply in english. I don't understand hindi.
Your solution is correct but in output table we need skill count too
So you have to select it that too
Thank you for this video, Rishabh!! Congratulations for completing 202K subscribers on this channel...
you are the best
Best ever tutor
Sir, aur question answer video channel mei post karo na.... bohot helpful hoga
New video coming tomo!!
very very useful
Glad you liked ✅️
40k congratulations ❤
Thanks Santosh ✅️
Please start series in English 😊
Awesome