06-06-aggregation.mp4

[@rachmaninov47]

yup, definitely best professor!!!

[@tangom3nas]

really informative! thank you, you're a great teacher!

[@chop-steak]

I'm using oracle DB and found an alternative SQL for the 0 valued count example(?), and it's: SELECT Student.sID, count(DISTINCT cName) FROM Student LEFT OUTER JOIN Apply ON Student.sID=Apply.sID GROUP BY Student.sID; Just wanted to share, that's all :)

[@ShuyanStoryTeller]

Jennifer, I love you. You are the best professor I have ever seen.

[@siyangliang5974]

You open a door for me

[@mohanpillimitla6434]

how to find sids,snames of students whose gpa's are equal

[@AdiJ8]

select S1.sID, S1.sName from Student S1 join Student S2 using(GPA) where S1.sID < S2.sID;

[@AnimilesYT]

Great at SQL, great at teaching and explaining, terrible at setting up a slightly decent microphone. I really wish she could do this again, but then with some help of someone who knows their audio stuff. I'm not a native English speaker, and it's sometimes a bit difficult to follow due to the audio quality. And yes, the audio quality is the only negative I can find. ^^