Query Function

In the attached example, I'm looking for help creating a query that allows me to filter data in the tab "Team Stats" and display those results in the tab "Query Results". In this example, I'm asking the hypothetical query function to look for the following variables in the "Team Stats" tab:

1) Is there a number greater than "4" in column "A" AND
2) Is there a "Yes" in column "D" AND
3) Is there no data in column "O"?

If any data (in one row) meets those three requirements, then I'd like the data from columns "A" through "AZ" in the "Team Stats" tab to appear in the "Query Results" tab, starting in cell A3.

If possible, I'd like the cells in the "Query Results" tab with values higher than the average (cells R33 to AZ33) to be conditionally formatted, but only if that's easy thing to do and explain.

Thank you.