Ad accounts per MMP

select advertiser, advertiser_id,'Adjust' as MMP, outcome_ltag 
from advertiser_lookup
where outcome_ltag in (
select distinct(l_tag) from new_pixel
where user_agent ='adjust.com'
and date = '2024-03-22')
union
select advertiser, advertiser_id, 'AppsFlyer' as MMP, outcome_ltag
from advertiser_lookup
where outcome_ltag in (
select distinct(l_tag) from new_pixel
where user_agent ='http-kit/2.0'
and date = '2024-03-22')
union
select advertiser, advertiser_id, 'Singular' as MMP, outcome_ltag
from advertiser_lookup
where outcome_ltag in (
select distinct(l_tag) from new_pixel
where user_agent ='Apsalar-Postback'
and date = '2024-03-22')
union
select advertiser, advertiser_id, 'Kochava' as MMP, outcome_ltag
from advertiser_lookup
where outcome_ltag in (
select distinct(l_tag) from new_pixel
where u11_tag ='Kochava'
and date = '2024-03-22')
order by MMP