gistfile1.txt

WITH clicks AS (
  SELECT ir.*, service_page_viewed as clicked
  FROM `sandbox.ir_ranking_training_ds_apr17_18` ir
  INNER JOIN `instant_results.search_results` s ON CAST(ir.service_pk AS INT64) = s.service_pk AND CAST(ir.search_request_pk as INT64) = s.search_request_pk
),

search_atleast_one_quote AS (
  SELECT search_request_pk, COUNTIF(quote_pk IS NOT NULL) as num_quotes
  FROM clicks
  GROUP BY 1
  HAVING num_quotes > 0
)

SELECT COUNT(DISTINCT search_request_pk) FROM search_atleast_one_quote