06-04-subqueries-in-where.mp4

[@fedebailaque3]

Thank you, this is very useful!

[@AnimilesYT]

10:47 - "And not surprisingly we get Berkley as a result". She appears to be a bit salty when it comes to that fact xD

[@djpunisha29]

i think Amy is a real person/student at Stanford and you know her :)

[@soberhippie]

She might not have selected Stanford at about 2:32

[@botelhorui]

thank you

[@RoshenRRujj]

i think she said something wrong when she said:
"So every college is in the same state as another college of the other college (i think: ..of the other state..?) could be the same college." because it didn't make sense. maybe im wrong. anyone can explain it better?

[@AnimilesYT]

A timestamp would be nice though. I didn't notice it, and I'm not going to watch the video again to try to find it..

[@nagendrababu4632]

How can we know? when to use subqueries and when to use joins?

[@chenli9349]

someone know the software in the video？ I mean the sql visualization

[@bubblegum3665]

+Chen Li SQLLite

[@正经人正不正经]

Database Master interface