Talkdesk app installs

.sql

select a.plan_type, sum(api.num_installs) installs
from accounts a
left outer join app_installs api on a.account_id = api.account_id and a.run_at = api.run_at and a.timespan = api.timespan
inner join apps ap on api.app_id = ap.id 
where a.run_at = 20150601
and ap.name like ('talkdesk')
and a.account_type = 'customer'
group by a.plan_type