06-05-subqueries-in-from-select.mp4

Help us caption and translate this video on Amara.org: www.amara.org/e...
Help us caption & translate this video!
amara.org/v/Blwu/

[@adnanashraf1279]

Thank you, your VDOs are very helpful and easy to understand. I need a help, if you could let us know resolving duplication by group by instead of distinct in the same example.

[@siyangliang5974]

In 6:46, why need to rename the column as GPA? Actually, the question should be why can you select an item that doesn't exist in College table?

[@botelhorui]

Siyang Liang She doesn't select a column from College. She computes a single row relation in the subquery using College.cName

[@onemanenclave]

Which SQL program are you using?

[@GokulNathXYZ]

It's SQLite.