SQL Interview Question || Swiggy Data Analyst Interview Question || Try Solving

[@sravankumar1767]

Superb explanation 👌 👏 👍

[@dataprojecthub]

Thanks for watching!

[@KuldeepKumar-rt8fs]

Bro, I am not getting same output, After executing select statement inside cte1. I am getting B English 1 For your B English 5

[@KapilKumar-hk9xk]

how come class b subjects are coming in reverse order of insertion and class b subjects are coming in order of insertion?

[@chandanpatra1053]

what if you have 10 subject . are you going to hardcode it. That means will you write 10 times case statement. Please bring a different approach.