-- don't need to bother with Team BY in the key question and so we do not have to put each of the SELECT values inside an aggregate purpose like MIN(). Theta-join is analogous to some Exclusive scenario of interior join in which the on is usually a theta comparison https://simon-pichie-kelowna92468.digitollblog.com/36415344/the-definitive-guide-to-how-to-join-outlaw-motorcycle-clubs