Задание для SQL Принятые + Пропущенные ВИТАЛЯ

declare @D1 datetime;
declare @D2  datetime;
declare @T1 datetime;
declare @T2  datetime;

set @D1 = cast(cast(GETDATE() as date)as datetime)
set @D2  = getdate()
set @T1 = '1900-01-01 00:00:00'
set @T2  = '1900-01-01 23:59:59'

DECLARE @TABLE_ TABLE  (CON_TYPE INT, USERID UNIQUEIDENTIFIER , [TASKID]  UNIQUEIDENTIFIER)

INSERT INTO @TABLE_ (CON_TYPE,USERID,[TASKID])

SELECT
        [A_Stat_Connections_1x1].[ConnectionType]
        ,[A_Stat_Connections_1x1_NEXT].[BUserId]
        ,(SELECT  top (1) IdTask  FROM [oktell_cc_temp].[dbo].[A_Cube_CC_EffortConnections]AS [A_Cube_CC_EffortConnections] with(nolock)
            WHERE IdChain = [A_Stat_Connections_1x1].IdChain)
  FROM [oktell].[dbo].[A_Stat_Connections_1x1]  AS [A_Stat_Connections_1x1] with(nolock)
  LEFT JOIN  [oktell].[dbo].[A_Stat_Connections_1x1] AS [A_Stat_Connections_1x1_NEXT]
  ON [A_Stat_Connections_1x1_NEXT].[ID] = [A_Stat_Connections_1x1].IdNext
  WHERE A_Stat_Connections_1x1.TimeStart between @D1 and @D2
  and [A_Stat_Connections_1x1].[ConnectionType] in(4) and [A_Stat_Connections_1x1].IdPrev IS NULL

declare @missed1 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = '319EC8C2-FE14-4C6C-AFA2-01FCBC718C14')
declare @answered1 int =(select COUNT(USERID)
from @TABLE_ where TASKID = '319EC8C2-FE14-4C6C-AFA2-01FCBC718C14')

declare @missed2 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = '173ABDEE-9CA2-4A7D-B4C4-42E4EE436C06')
declare @answered2 int =(select COUNT(USERID)
from @TABLE_ where TASKID = '173ABDEE-9CA2-4A7D-B4C4-42E4EE436C06')

declare @missed3 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = '1978EA8D-1838-4CF0-B5EE-70AEC7C88315')
declare @answered3 int =(select COUNT(USERID)
from @TABLE_ where TASKID = '1978EA8D-1838-4CF0-B5EE-70AEC7C88315')

declare @missed4 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = '6830E035-0316-4799-9034-6CBBD6D89C4E')
declare @answered4 int =(select COUNT(USERID)
from @TABLE_ where TASKID = '6830E035-0316-4799-9034-6CBBD6D89C4E')

declare @missed5 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = 'FE2DE479-0F34-4AE9-8DB2-01F6EAC482C1')
declare @answered5 int =(select COUNT(USERID)
from @TABLE_ where TASKID = 'FE2DE479-0F34-4AE9-8DB2-01F6EAC482C1')

declare @missed6 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = '1EB1A40F-48AA-48BF-836A-A5F437D4E9B6')
declare @answered6 int =(select COUNT(USERID)
from @TABLE_ where TASKID = '1EB1A40F-48AA-48BF-836A-A5F437D4E9B6')

declare @missed7 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = 'D69A7932-9761-44A4-8B03-E3BFD8577557')
declare @answered7 int =(select COUNT(USERID)
from @TABLE_ where TASKID = 'D69A7932-9761-44A4-8B03-E3BFD8577557')

declare @missed8 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = 'B4CDB351-343C-4854-B024-090ED195F31C')
declare @answered8 int =(select COUNT(USERID)
from @TABLE_ where TASKID = 'B4CDB351-343C-4854-B024-090ED195F31C')

declare @missed9 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = 'BBC7F13A-B219-413B-A8A3-4FC6D1325EC0')
declare @answered9 int =(select COUNT(USERID)
from @TABLE_ where TASKID = 'BBC7F13A-B219-413B-A8A3-4FC6D1325EC0')

declare @missed10 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = '4AB8D485-4F73-4F6B-B4A5-AAB8F2B3C1A7')
declare @answered10 int =(select COUNT(USERID)
from @TABLE_ where TASKID = '4AB8D485-4F73-4F6B-B4A5-AAB8F2B3C1A7')

declare @missed11 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = '667E72FF-3EE4-428E-8D54-899A5E9A32CB')
declare @answered11 int =(select COUNT(USERID)
from @TABLE_ where TASKID = '667E72FF-3EE4-428E-8D54-899A5E9A32CB')

declare @missed12 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = '9DC79009-F8B6-4EF7-B405-98BE950C5B72')
declare @answered12 int =(select COUNT(USERID)
from @TABLE_ where TASKID = '9DC79009-F8B6-4EF7-B405-98BE950C5B72')

declare @missed13 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = '63C1876A-2FC0-4A62-8B16-B0515D20A5D1')
declare @answered13 int =(select COUNT(USERID)
from @TABLE_ where TASKID = '63C1876A-2FC0-4A62-8B16-B0515D20A5D1')

declare @missed14 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = '1E7BA857-4A1A-4E76-98B0-24273C1120C7')
declare @answered14 int =(select COUNT(USERID)
from @TABLE_ where TASKID = '1E7BA857-4A1A-4E76-98B0-24273C1120C7')

declare @missed15 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = 'D7E48FA6-0061-4EBB-A231-B32F690FD527')
declare @answered15 int =(select COUNT(USERID)
from @TABLE_ where TASKID = 'D7E48FA6-0061-4EBB-A231-B32F690FD527')

declare @missed17 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = '08533862-B6A6-4CC8-8C84-F038AEC5EAF9')
declare @answered17 int =(select COUNT(USERID)
from @TABLE_ where TASKID = '08533862-B6A6-4CC8-8C84-F038AEC5EAF9')

declare @missed18 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = 'A848E0ED-6554-4472-80D5-9A55640BE384')
declare @answered18 int =(select COUNT(USERID)
from @TABLE_ where TASKID = 'A848E0ED-6554-4472-80D5-9A55640BE384')

declare @missed19 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = '30FBFBB3-74A1-4021-8A32-395CCBFBFCD4')
declare @answered19 int =(select COUNT(USERID)
from @TABLE_ where TASKID = '30FBFBB3-74A1-4021-8A32-395CCBFBFCD4')

declare @missed20 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = 'EBB40B52-2E39-4F96-8DF9-9159A2EACAE4')
declare @answered20 int =(select COUNT(USERID)
from @TABLE_ where TASKID = 'EBB40B52-2E39-4F96-8DF9-9159A2EACAE4')

declare @missed21 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = 'DFF64BE9-074F-486A-BE74-20CA1E9D306A')
declare @answered21 int =(select COUNT(USERID)
from @TABLE_ where TASKID = 'DFF64BE9-074F-486A-BE74-20CA1E9D306A')

declare @missed22 int =(select COUNT(CON_TYPE)-COUNT(USERID)
from @TABLE_ where TASKID = '5DE3F3EF-8514-4073-A6AA-5AC6B96A558C')
declare @answered22 int =(select COUNT(USERID)
from @TABLE_ where TASKID = '5DE3F3EF-8514-4073-A6AA-5AC6B96A558C')

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered1+@missed1=0 then 0 else  (select cast(cast(@answered1*100 as decimal(10,2))/cast(@answered1+@missed1 as decimal(10,2))as decimal(5,2)))end),
missed = @missed1,
answered = @answered1
where id = 1

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered2+@missed2=0 then 0 else  (select cast(cast(@answered2*100 as decimal(10,2))/cast(@answered2+@missed2 as decimal(10,2))as decimal(5,2)))end),
missed = @missed2,
answered = @answered2
where id = 2

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered3+@missed3=0 then 0 else  (select cast(cast(@answered3*100 as decimal(10,2))/cast(@answered3+@missed3 as decimal(10,2))as decimal(5,2)))end),
missed = @missed3,
answered = @answered3
where id = 3

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered4+@missed4=0 then 0 else  (select cast(cast(@answered4*100 as decimal(10,2))/cast(@answered4+@missed4 as decimal(10,2))as decimal(5,2)))end),
missed = @missed4,
answered = @answered4
where id = 4

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered5+@missed5=0 then 0 else  (select cast(cast(@answered5*100 as decimal(10,2))/cast(@answered5+@missed5 as decimal(10,2))as decimal(5,2)))end),
missed = @missed5,
answered = @answered5
where id = 5

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered6+@missed6=0 then 0 else  (select cast(cast(@answered6*100 as decimal(10,2))/cast(@answered6+@missed6 as decimal(10,2))as decimal(5,2)))end),
missed = @missed6,
answered = @answered6
where id = 6

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered7+@missed7=0 then 0 else  (select cast(cast(@answered7*100 as decimal(10,2))/cast(@answered7+@missed7 as decimal(10,2))as decimal(5,2)))end),
missed = @missed7,
answered = @answered7
where id = 7

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered8+@missed8=0 then 0 else  (select cast(cast(@answered8*100 as decimal(10,2))/cast(@answered8+@missed8 as decimal(10,2))as decimal(5,2)))end),
missed = @missed8,
answered = @answered8
where id = 8

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered9+@missed9=0 then 0 else  (select cast(cast(@answered9*100 as decimal(10,2))/cast(@answered9+@missed9 as decimal(10,2))as decimal(5,2)))end),
missed = @missed9,
answered = @answered9
where id = 9

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered10+@missed10=0 then 0 else  (select cast(cast(@answered10*100 as decimal(10,2))/cast(@answered10+@missed10 as decimal(10,2))as decimal(5,2)))end),
missed = @missed10,
answered = @answered10
where id = 10

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered11+@missed11=0 then 0 else  (select cast(cast(@answered11*100 as decimal(10,2))/cast(@answered11+@missed11 as decimal(10,2))as decimal(5,2)))end),
missed = @missed11,
answered = @answered11
where id = 11

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered12+@missed12=0 then 0 else  (select cast(cast(@answered12*100 as decimal(10,2))/cast(@answered12+@missed12 as decimal(10,2))as decimal(5,2)))end),
missed = @missed12,
answered = @answered12
where id = 12

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered13+@missed13=0 then 0 else  (select cast(cast(@answered13*100 as decimal(10,2))/cast(@answered13+@missed13 as decimal(10,2))as decimal(5,2)))end),
missed = @missed13,
answered = @answered13
where id = 13

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered14+@missed14=0 then 0 else  (select cast(cast(@answered14*100 as decimal(10,2))/cast(@answered14+@missed14 as decimal(10,2))as decimal(5,2)))end),
missed = @missed14,
answered = @answered14
where id = 14

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered15+@missed15=0 then 0 else  (select cast(cast(@answered15*100 as decimal(10,2))/cast(@answered15+@missed15 as decimal(10,2))as decimal(5,2)))end),
missed = @missed15,
answered = @answered15
where id = 15

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered17+@missed17=0 then 0 else  (select cast(cast(@answered17*100 as decimal(10,2))/cast(@answered17+@missed17 as decimal(10,2))as decimal(5,2)))end),
missed = @missed17,
answered = @answered17
where id = 17

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered18+@missed18=0 then 0 else  (select cast(cast(@answered18*100 as decimal(10,2))/cast(@answered18+@missed18 as decimal(10,2))as decimal(5,2)))end),
missed = @missed18,
answered = @answered18
where id = 18

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered19+@missed19=0 then 0 else  (select cast(cast(@answered19*100 as decimal(10,2))/cast(@answered19+@missed19 as decimal(10,2))as decimal(5,2)))end),
missed = @missed19,
answered = @answered19
where id = 19

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered20+@missed20=0 then 0 else  (select cast(cast(@answered20*100 as decimal(10,2))/cast(@answered20+@missed20 as decimal(10,2))as decimal(5,2)))end),
missed = @missed20,
answered = @answered20
where id = 20

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered21+@missed21=0 then 0 else  (select cast(cast(@answered21*100 as decimal(10,2))/cast(@answered21+@missed21 as decimal(10,2))as decimal(5,2)))end),
missed = @missed21,
answered = @answered21
where id = 21

update oktell.dbo.tbl_dashboardgrafana_tasks
SET
coverage = (select case when @answered22+@missed22=0 then 0 else  (select cast(cast(@answered22*100 as decimal(10,2))/cast(@answered22+@missed22 as decimal(10,2))as decimal(5,2)))end),
missed = @missed22,
answered = @answered22
where id = 22