All pastes #593396 Raw Edit

Someone

public text v1 · immutable
#593396 ·published 2007-06-28 09:36 UTC
rendered paste body
query 1.select operator_id,
sum(blocked) as blocked,
count(distinct(customer_id)) as customer from fact_roaming where blocked =1 and entry_type_id=2 
group by operator_id order by 2 desc limit 4

query 2.select operator_id,
sum(blocked) as blocked,
count(distinct(customer_id)) as customer from fact_roaming where blocked =1 and entry_type_id=1 
group by operator_id order by 2 desc limit 4;

how can i union these two queries using union