Interpreting a MySQL nested SELECT statement (6 Solutions!!)

Description:
Interpreting a MySQL nested SELECT statement

Helpful? Please use the *Thanks* button above! Or, thank me via Patreon: https://www.patreon.com/roelvandepaar!

With thanks & praise to God, and with thanks to the many people who have made this project possible! | Content (except music & images) licensed under CC BY-SA https://meta.stackexchange.com/help/licensing | Music: https://www.bensound.com/licensing | Images: https://stocksnap.io/license & others | With thanks to user zw324 (stackoverflow.com/users/688653), user wkl (stackoverflow.com/users/297696), user Patrick87 (stackoverflow.com/users/847269), user Oded (stackoverflow.com/users/1583), user Nebril (stackoverflow.com/users/563158), user Michael Berkowski (stackoverflow.com/users/541091), user Marc B (stackoverflow.com/users/118068), and the Stack Exchange Network (stackoverflow.com/questions/6753822). Trademarks are property of their respective owners. Disclaimer: All information is provided "AS IS" without warranty of any kind. You are responsible for your own actions. Please contact me if anything is amiss at Roel D.OT VandePaar A.T gmail.com