a.py

x0 = sqlContext.sql("""
select 
client_id,
substr(subsession_start_date,0,10) as date,
case when (sum(plugin_hangs) + sum(crashes_detected_plugin) + sum(crashes_detected_gmplugin ))  > 0 then 1 else 0 end as cpq,
case when sum(crashes_detected_content)>0 then 1 else 0 end as ccq
from frame
where channel='release' and app_name = 'Firefox' and  vendor='Mozilla' and sample_id in (1,2,3,4,5,6,7,8,9,10)
and  substr(subsession_start_date,0,10) >='2016-07-25' and substr(subsession_start_date,0,10) <= '2016-08-30'
and client_id is not null
group by client_id,substr(subsession_start_date,0,10)
""")
x0.registerTempTable("x0")

x1=sqlContext.sql("""
    select date, cpq,ccq, count(distinct(client_id)) as n 
   from x0 group by date,cpq,ccq 
   order by date, cpq, ccq
   """).collect()