Félög: Sigrar - karla — Deildarkeppni

Sigrar — heild

Félag	Leikir	Sigrar	Töp	Sigur %
Njarðvík	1181	798	383	67,6%
KR	1256	798	458	63,5%
Keflavík	975	671	304	68,8%
Grindavík	895	575	320	64,2%
ÍR	1136	564	572	49,6%
Haukar	843	433	410	51,4%
Tindastóll	835	422	413	50,5%
Valur	855	384	471	44,9%
Stjarnan	439	251	188	57,2%
Snæfell	538	241	297	44,8%
Skallagrímur	544	199	345	36,6%
Þór Þ	373	189	184	50,7%
Þór Ak	595	165	430	27,7%
Ármann	243	112	131	46,1%
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	200	65	135	32,5%
Fjölnir	219	65	154	29,7%
Höttur	154	40	114	26,0%
KFR	88	33	55	37,5%
Álftanes	66	32	34	48,5%
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	626	443	183	70,8%
Njarðvík	591	428	163	72,4%
Keflavík	488	388	100	79,5%
ÍR	579	337	242	58,2%
Grindavík	447	331	116	74,0%
Haukar	421	252	169	59,9%
Tindastóll	418	247	171	59,1%
Valur	429	216	213	50,3%
Stjarnan	220	148	72	67,3%
Snæfell	269	145	124	53,9%
Skallagrímur	272	134	138	49,3%
Þór Ak	298	112	186	37,6%
Þór Þ	186	108	78	58,1%
Hamar	132	62	70	47,0%
Ármann	120	60	60	50,0%
ÍS	148	53	95	35,8%
ÍA	100	46	54	46,0%
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	33	20	13	60,6%
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	590	370	220	62,7%
KR	630	355	275	56,3%
Keflavík	487	283	204	58,1%
Grindavík	448	244	204	54,5%
ÍR	557	227	330	40,8%
Haukar	422	181	241	42,9%
Tindastóll	417	175	242	42,0%
Valur	426	168	258	39,4%
Stjarnan	219	103	116	47,0%
Snæfell	269	96	173	35,7%
Þór Þ	187	81	106	43,3%
Skallagrímur	272	65	207	23,9%
Þór Ak	297	53	244	17,8%
Ármann	123	52	71	42,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	100	19	81	19,0%
Höttur	77	18	59	23,4%
Fram	63	16	47	25,4%
ÍKF	41	15	26	36,6%
Álftanes	33	12	21	36,4%
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