SELECT org_id, count(distinct entry_id) as entry_point, sum(total_device) as total_device, sum(active_device) as active_device,
sum(total_tablet) as total_tablet, sum(active_tablet) as active_tablet,
sum(total_desktop) as total_desktop, sum(active_desktop) as active_desktop, sum(in_cnt) as din_cnt, sum(out_cnt) as dout_cnt
FROM dashboard_device GROUP BY org_id