Your video(s) are really helpful. . I have tried this query - Just an update in place of " " we've to use ' '. Final query should look like :- SELECT CONCAT('There are a total of ',COUNT(*),' ',LOWER(Occupation),'s') FROM OCCUPATION GROUP BY OCCUPATION ORDER BY COUNT(OCCUPATION),LOWER(OCCUPATION).
@@yourfavouriterecipes505 While sorting data in the ascending order.Sometimes we get output , where COUNT values are similar (for e.g: 2,2,....etc.), thats why she had used another column to sort data as per the requirement, due to which overhere [ lower(occupation) ] is added at the end of the code. . She has explained this in her video.Please skip and listen at 05:20.
Hi, I have learnt to join multiple tables from you. I want to send you a file and my question, please make a video on that. Please provide your email Id. Thanks in advance.
8 years old kids can also learn it because of your good explanation.
This channel is amazing. Never came across such a detailed explanation for SQL anywhere.
Thank you 😊
Can you please also have a playlist on datastructures and algorithms?
Helpful
Solved all my Doubts about like Everything related sql queries, best channel ever. :)
Amazing explanation, thank you
Glad it was helpful!
The count in the Select statement shouldn't be count(occupation) instead of count (*)?
Right
You are doing an amazing job. Thank you very much
Good work. Keep updating more such difficult interview queries.
Your video(s) are really helpful.
.
I have tried this query - Just an update in place of " " we've to use ' '.
Final query should look like :-
SELECT CONCAT('There are a total of ',COUNT(*),' ',LOWER(Occupation),'s')
FROM OCCUPATION
GROUP BY OCCUPATION
ORDER BY COUNT(OCCUPATION),LOWER(OCCUPATION).
Why is it 'lower(occupation)' in the end?
@@yourfavouriterecipes505 While sorting data in the ascending order.Sometimes we get output , where COUNT values are similar (for e.g: 2,2,....etc.), thats why she had used another column to sort data as per the requirement, due to which overhere [ lower(occupation) ] is added at the end of the code.
.
She has explained this in her video.Please skip and listen at 05:20.
@@raviprakash5468 oh....so if there are 2 actors and 2 comedians..we'll we get 2 actors written first and then 2 comedians. Right?
Awesome voice ❤️.... Beauty with brain
plz keep uploading these kinds of videos
Amazing videos saved my life
Great video but one doubt, in another video you had use ' ' in concat but here used " " which of them is correct please mention
Thankyou didi 🙏.... amazing videos 🔥
Thanks a lot!!!
Grt job..👍
Nice sadia
Will u able to share the dump
What if the count of occupation is 1? Then how can be make sure that occupation doesn't print with 's' at the end.
Group by should follow order by...
So you did watch "friends"...
Tricky queries tx
Hi, I have learnt to join multiple tables from you. I want to send you a file and my question, please make a video on that. Please provide your email Id. Thanks in advance.