How might Subqueries be overcome in Zoho (Query table) ?

How might Subqueries be overcome in Zoho (Query table) ?

Hi SQL Zoho Experts,

Apparently Zoho does not seem to accept Subqueries with the SELECT statement, could someone has a solution to count null values for each column by location ? Many thanks. Sqilias

SELECT "Business unit", "Location",
COUNT('ZIP') AS "ZIP NULL",
COUNT('Birth date') AS "Birth date",
COUNT('Nationality') AS "Nationality",
COUNT('Company') AS "Company",
FROM "TABLE"
WHERE "ZIP" IS NULL
OR "Birth date" IS NULL
OR "Nationality" IS NULL
OR "Company" IS NULL
GROUP BY "Location"