Félög: Sigrar - karla — Deildarkeppni

Sigrar — heild

Félag	Leikir	Sigrar	Töp	Sigur %
Njarðvík	1178	797	381	67,7%
KR	1253	797	456	63,6%
Keflavík	972	670	302	68,9%
Grindavík	892	573	319	64,2%
ÍR	1133	561	572	49,5%
Haukar	843	433	410	51,4%
Tindastóll	832	419	413	50,4%
Valur	852	383	469	45,0%
Stjarnan	436	250	186	57,3%
Snæfell	538	241	297	44,8%
Skallagrímur	544	199	345	36,6%
Þór Þ	370	188	182	50,8%
Þór Ak	595	165	430	27,7%
Ármann	240	109	131	45,4%
Hamar	264	93	171	35,2%
ÍS	299	93	206	31,1%
KFÍ	220	71	149	32,3%
Breiðablik	308	70	238	22,7%
ÍA	197	65	132	33,0%
Fjölnir	219	65	154	29,7%
Höttur	154	40	114	26,0%
KFR	88	33	55	37,5%
Álftanes	63	31	32	49,2%
Fram	122	31	91	25,4%
ÍKF	67	26	41	38,8%
HSK	68	17	51	25,0%
FSu	66	11	55	16,7%
Gosi	19	7	12	36,8%
Vestri	22	4	18	18,2%
KFR b	8	2	6	25,0%
Reynir S	26	1	25	3,8%
ÍBA	2	0	2	0,0%

Sigrar — heima

Félag	Leikir	Sigrar	Töp	Sigur %
KR	624	442	182	70,8%
Njarðvík	589	427	162	72,5%
Keflavík	487	388	99	79,7%
ÍR	578	336	242	58,1%
Grindavík	445	329	116	73,9%
Haukar	421	252	169	59,9%
Tindastóll	417	246	171	59,0%
Valur	428	216	212	50,5%
Stjarnan	219	147	72	67,1%
Snæfell	269	145	124	53,9%
Skallagrímur	272	134	138	49,3%
Þór Ak	298	112	186	37,6%
Þór Þ	184	107	77	58,2%
Hamar	132	62	70	47,0%
Ármann	119	59	60	49,6%
ÍS	148	53	95	35,8%
ÍA	98	46	52	46,9%
KFÍ	110	46	64	41,8%
Breiðablik	154	43	111	27,9%
Fjölnir	109	39	70	35,8%
KFR	45	24	21	53,3%
Höttur	77	22	55	28,6%
Álftanes	31	19	12	61,3%
Fram	59	15	44	25,4%
ÍKF	26	11	15	42,3%
HSK	34	9	25	26,5%
Gosi	10	6	4	60,0%
FSu	33	4	29	12,1%
Vestri	11	2	9	18,2%
KFR b	4	1	3	25,0%
Reynir S	13	1	12	7,7%
ÍBA	1	0	1	0,0%

Sigrar — úti

Félag	Leikir	Sigrar	Töp	Sigur %
Njarðvík	589	370	219	62,8%
KR	629	355	274	56,4%
Keflavík	485	282	203	58,1%
Grindavík	447	244	203	54,6%
ÍR	555	225	330	40,5%
Haukar	422	181	241	42,9%
Tindastóll	415	173	242	41,7%
Valur	424	167	257	39,4%
Stjarnan	217	103	114	47,5%
Snæfell	269	96	173	35,7%
Þór Þ	186	81	105	43,5%
Skallagrímur	272	65	207	23,9%
Þór Ak	297	53	244	17,8%
Ármann	121	50	71	41,3%
ÍS	151	40	111	26,5%
Hamar	132	31	101	23,5%
Breiðablik	154	27	127	17,5%
Fjölnir	110	26	84	23,6%
KFÍ	110	25	85	22,7%
ÍA	99	19	80	19,2%
Höttur	77	18	59	23,4%
Fram	63	16	47	25,4%
ÍKF	41	15	26	36,6%
Álftanes	32	12	20	37,5%
KFR	43	9	34	20,9%
HSK	34	8	26	23,5%
FSu	33	7	26	21,2%
Vestri	11	2	9	18,2%
KFR b	4	1	3	25,0%
Gosi	9	1	8	11,1%
ÍBA	1	0	1	0,0%
Reynir S	13	0	13	0,0%

Debug SQL Queries

        
WITH WinsLosses AS (
  SELECT LTRIM(RTRIM(COALESCE(NULLIF(L.HeimalidHeiti,''), L.Heimalid))) AS Felag, COUNT(*) AS Wins, 0 AS Losses
  FROM dbo.kkiLeikirKa L
  WHERE L.Mot LIKE '%001' AND L.HeimalidMork > L.UtilidMork AND L.Timabil <= 2050
  GROUP BY LTRIM(RTRIM(COALESCE(NULLIF(L.HeimalidHeiti,''), L.Heimalid)))
  UNION ALL
  SELECT LTRIM(RTRIM(COALESCE(NULLIF(L.HeimalidHeiti,''), L.Heimalid))) AS Felag, 0 AS Wins, COUNT(*) AS Losses
  FROM dbo.kkiLeikirKa L
  WHERE L.Mot LIKE '%001' AND L.HeimalidMork < L.UtilidMork AND L.Timabil <= 2050
  GROUP BY LTRIM(RTRIM(COALESCE(NULLIF(L.HeimalidHeiti,''), L.Heimalid)))
  UNION ALL
  SELECT LTRIM(RTRIM(COALESCE(NULLIF(L.UtilidHeiti,''),   L.Utilid))) AS Felag, COUNT(*) AS Wins, 0 AS Losses
  FROM dbo.kkiLeikirKa L
  WHERE L.Mot LIKE '%001' AND L.UtilidMork > L.HeimalidMork AND L.Timabil <= 2050
  GROUP BY LTRIM(RTRIM(COALESCE(NULLIF(L.UtilidHeiti,''),   L.Utilid)))
  UNION ALL
  SELECT LTRIM(RTRIM(COALESCE(NULLIF(L.UtilidHeiti,''),   L.Utilid))) AS Felag, 0 AS Wins, COUNT(*) AS Losses
  FROM dbo.kkiLeikirKa L
  WHERE L.Mot LIKE '%001' AND L.UtilidMork < L.HeimalidMork AND L.Timabil <= 2050
  GROUP BY LTRIM(RTRIM(COALESCE(NULLIF(L.UtilidHeiti,''),   L.Utilid)))
)
SELECT
  Felag,
  (SUM(Wins)+SUM(Losses)) AS Leikir,
  SUM(Wins)               AS Sigurleikir,
  SUM(Losses)             AS Tapleikir,
  ROUND(CAST((SUM(Wins) * 100.0 / NULLIF(SUM(Wins) + SUM(Losses),0)) AS DECIMAL(5,1)), 1) AS Sigurhlutfall
FROM WinsLosses
GROUP BY Felag
ORDER BY Sigurleikir DESC, Tapleikir ASC, Felag ASC;
      

        
WITH WinsLosses AS (
  SELECT LTRIM(RTRIM(COALESCE(NULLIF(L.HeimalidHeiti,''), L.Heimalid))) AS Felag, COUNT(*) AS Wins, 0 AS Losses
  FROM dbo.kkiLeikirKa L
  WHERE L.Mot LIKE '%001' AND L.HeimalidMork > L.UtilidMork AND L.Timabil <= 2050
  GROUP BY LTRIM(RTRIM(COALESCE(NULLIF(L.HeimalidHeiti,''), L.Heimalid)))
  UNION ALL
  SELECT LTRIM(RTRIM(COALESCE(NULLIF(L.HeimalidHeiti,''), L.Heimalid))) AS Felag, 0 AS Wins, COUNT(*) AS Losses
  FROM dbo.kkiLeikirKa L
  WHERE L.Mot LIKE '%001' AND L.HeimalidMork < L.UtilidMork AND L.Timabil <= 2050
  GROUP BY LTRIM(RTRIM(COALESCE(NULLIF(L.HeimalidHeiti,''), L.Heimalid)))
)
SELECT
  Felag,
  (SUM(Wins)+SUM(Losses)) AS Leikir,
  SUM(Wins)               AS Sigurleikir,
  SUM(Losses)             AS Tapleikir,
  ROUND(CAST((SUM(Wins) * 100.0 / NULLIF(SUM(Wins) + SUM(Losses),0)) AS DECIMAL(5,1)), 1) AS Sigurhlutfall
FROM WinsLosses
GROUP BY Felag
ORDER BY Sigurleikir DESC, Tapleikir ASC, Felag ASC;
      

        
WITH WinsLosses AS (
  SELECT LTRIM(RTRIM(COALESCE(NULLIF(L.UtilidHeiti,''),   L.Utilid))) AS Felag, COUNT(*) AS Wins, 0 AS Losses
  FROM dbo.kkiLeikirKa L
  WHERE L.Mot LIKE '%001' AND L.UtilidMork > L.HeimalidMork AND L.Timabil <= 2050
  GROUP BY LTRIM(RTRIM(COALESCE(NULLIF(L.UtilidHeiti,''),   L.Utilid)))
  UNION ALL
  SELECT LTRIM(RTRIM(COALESCE(NULLIF(L.UtilidHeiti,''),   L.Utilid))) AS Felag, 0 AS Wins, COUNT(*) AS Losses
  FROM dbo.kkiLeikirKa L
  WHERE L.Mot LIKE '%001' AND L.UtilidMork < L.HeimalidMork AND L.Timabil <= 2050
  GROUP BY LTRIM(RTRIM(COALESCE(NULLIF(L.UtilidHeiti,''),   L.Utilid)))
)
SELECT
  Felag,
  (SUM(Wins)+SUM(Losses)) AS Leikir,
  SUM(Wins)               AS Sigurleikir,
  SUM(Losses)             AS Tapleikir,
  ROUND(CAST((SUM(Wins) * 100.0 / NULLIF(SUM(Wins) + SUM(Losses),0)) AS DECIMAL(5,1)), 1) AS Sigurhlutfall
FROM WinsLosses
GROUP BY Felag
ORDER BY Sigurleikir DESC, Tapleikir ASC, Felag ASC;
      

Raða eftir	Mótshluti	Kyn