MySQL split row into 2 columns and group by, is that possible?

I got a table with 2 columns app and grupo_id

select count(*) total, app, grupo_id from devices d group by app, grupo_id ;

output:

so the app I would like to split into 2 columns app-on and app-off and group them by grupo-id

Expected output:

is that possible is that possible ?

Use conditional aggregation:

SELECT SUM(app = 1) app_on, 
       SUM(app = 0) app_off,
       grupo_id
FROM devices 
GROUP BY grupo_id;

or:

SELECT SUM(app) app_on, 
       SUM(NOT app) app_off,
       grupo_id
FROM devices 
GROUP BY grupo_id;