convert this query into storeprocedure

[Piyali]

SELECT org_id, count(distinct entry_id) as entry_point, sum(total_devic e) as total_device, sum(active_devi ce) as active_device,
sum(total_table t) as total_tablet, sum(active_tabl et) as active_tablet,
sum(total_deskt op) as total_desktop, sum(active_desk top) as active_desktop, sum(in_cnt) as din_cnt, sum(out_cnt) as dout_cnt
FROM dashboard_devic e GROUP BY org_id

[Frinavale]

Use the Create Procedure statement to create your procedure...

See this documentation for the CREATE PROCEDURE and CREATE FUNCTION Syntax.