Cannot execute SELECT query.

SELECT week_picks.7_1, t.CITY, t.TEAMNAME, COUNT(week_picks.7_1) AS COUNT FROM ((SELECT p1.PLAYER_NAME, p1.7_1 FROM survivor_standings p1 WHERE p1.PLAYER_STATUS = 'ALIVE' AND p1.SEASON = '2021' AND p1.POOL_ID = '' AND p1.DELETED = 'NO' AND p1.DEADBEAT = 'NO') UNION (SELECT p2.PLAYER_NAME, p2.7_1 FROM survivor_standings p2 WHERE p2. = '1' AND p2.SEASON = '2021' AND p2.POOL_ID = '' AND p2.DELETED = 'NO' AND p2.DEADBEAT = 'NO')) as week_picks, nfl_teams t WHERE week_picks.7_1 = t.TEAMCODE GROUP BY week_picks.7_1, t.CITY, t.TEAMNAME ORDER BY COUNT DESC