Joomla: Method for creating a subquery using JDatabase

Method for creating a subquery using JDatabase
Hey guys! Hopefully you found a solution that helped you!
The Content is licensed under (https://meta.stackexchange.com/help/l...) CC BY-SA.
Attention! This video does always use the same license as the source!
Thanks to all the great people for their contributions!

(joomla.stackexchange.com/users/14/betweenbrain)betweenbrain
(joomla.stackexchange.com/users/157/skullbock)Skullbock
(joomla.stackexchange.com/users/70/don-gilbert)Don Gilbert
(joomla.stackexchange.com/users/2238/mario-neubauer)Mario Neubauer
(joomla.stackexchange.com/users/12352/mickmackusa)mickmackusa
A special thanks goes out to the awesome (joomla.stackexchange.com/questions/1/method-for-creating-a-subquery-using-jdatabase)Stackexchange community

If anything is off, please write me at sophia DO.T wagner A.T ois42.de
I wish you all a chilled day! Stay safe :)

mysql database jdatabase php