https://www.study24x7.com/post/27135/sql-applies-predicates-in-the-clause-after-groups-have-0