orchestration_session_by_device

Column	Type
device_id	VARCHAR
device_name	TEXT
session_count

SQL DDL

CREATE VIEW orchestration_session_by_device AS
 SELECT
     d.device_id,
     d.name AS device_name,
     COUNT(*) AS session_count
 FROM orchestration_session os
 JOIN device d ON os.device_id = d.device_id
 GROUP BY d.device_id, d.name