How to group a view by the tables from which it gathers its data?
Maybe you need

CREATE VIEW my_view 
AS 
SELECT *, 'LAMPS' AS TABLE_NAME FROM LAMPS WHERE STATUS = 'OFF'
UNION ALL
SELECT *, 'CARS'                FROM CARS WHERE STATUS = 'OFF'
UNION ALL
SELECT *, 'DRONES'              FROM DRONES WHERE STATUS = 'OFF'
UNION ALL
SELECT *, 'OVENS'               FROM OVENS WHERE STATUS = 'OFF';


?