How many users installed the app but are not active?
installed refers to is_installed = 1; not active refers to is_active = 0;
SELECT COUNT(app_id) FROM app_events WHERE is_installed = 1 AND is_active = 0