[BigQuery using parameterised query in the console]

bigquery-use-parameterised-query.sql

DECLARE ORG_NAME STRING;
SET ORG_NAME = "AFL";
EXECUTE IMMEDIATE """
WITH x as
(
select 
     country
   , category
   , subcategory
   , organisation
   , id
   from events_prod.mobile_apps
)   
SELECT 
  country
, category
, subcategory
, organisation
, COUNT(DISTINCT id) as cnt_apps
, COUNT(1) AS cnt_rows
FROM x
cross join UNNEST(x.country) as country
WHERE organisation = @ORG_NAME
   GROUP BY 
    country
  , category
  , subcategory
  , organisation
"""
USING ORG_NAME as ORG_NAME;