Thank you, Alisha. Your knowledge and command over SQL are fabulous. I start watching your videos for few weeks ago and now if I got stuck in any problem your videos help me a lot. Thanks, you are once again.
She forgot below condition If there is more than one student with the same grade (1-7) assigned to them, order those particular students by their marks in ascending order. It is mentioned in problem statement
/* Required output : Name, grade, mark Given conditions : grade >= 8 then NAME ORDER BY grade DESC , name ASC grade < 8 : put NULL as name ORDER BY marks ASC */ SELECT IF(G.Grade
Thank you, Alisha. Your knowledge and command over SQL are fabulous. I start watching your videos for few weeks ago and now if I got stuck in any problem your videos help me a lot. Thanks, you are once again.
So far the best explanation i got on youtube on this report problem
you made it so simple
She forgot below condition
If there is more than one student with the same grade (1-7) assigned to them, order those particular students by their marks in ascending order.
It is mentioned in problem statement
/*
Required output :
Name, grade, mark
Given conditions :
grade >= 8 then NAME
ORDER BY grade DESC , name ASC
grade < 8 : put NULL as name
ORDER BY marks ASC
*/
SELECT IF(G.Grade
so if we have no common columns in tables we use where clause to join.?
i was trapped in this only.
Nice can u make more videos on joins😊 explanation is good
Really good explanation
I was taught MS SQL Server, So my question is that, Codes in My SQL and MS SQL Server are same or different.
Good work 👍👍👍
Can you please provide explanation in MS SQL ?
still some doubt here maybe after writing the code you may have explained it by breaking it into small parts
Thank you for you easy way, easy to understand. Keep going
I was taught MS SQL Server, So my question is that, Codes in My SQL and MS SQL Server are same or different.
@@Black_Hawk007 almost same, somewhere you can find difference in code,
Best one
people dont care even about our names if grade is less than 8
helpful thanks!
Great explanation
I was taught MS SQL Server, So my question is that, Codes in My SQL and MS SQL Server are same or different.
U should provide codes as well
it is not working
this is simple one .tq