Write SQL Query to get values and total frequency in a category.| #sqlinterviewquestionsandanswers

Question :- Write SQL Query to get Student Name and number of Students in same grade.

Option 1- WITH clause
We can use WITH clause for this problem. We first get the number students in each grade by using GROUP BY on grade. Then we use Sub-Query returned by WITH clause in Main query.

Option 2 - By Using Joins and Sub query

If you want to be better in Analytics, then do follow the below Playlist:-
Excel Playlist:-   • What is MS Excel | Introduction To Excel |...  

SQL Playlist:-    • Introduction to SQL | SQL For Beginners | ...  

Google Data Studio playlist:-    • Introduction to Looker|Introduction to Goo...  


You can follow us on the below social media handles:-
Blog: - thedatamillennials.blogspot.com/
Facebook:- www.facebook.com/The-Data-Millennials-596575371027…
Instagram: - www.instagram.com/the_data_millennials/
LinkedIn: - www.linkedin.com/in/data-millennials-6b5a031b3/
Twitter: - twitter.com/DataMillennials