Write SQL query to solve given problem: Identify all installed and activated apps by their id.. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT app_id FROM app_events WHERE is_active = 1 AND is_installed = 1