Félög: Sigrar - karla — Deildarkeppni

Sigrar — heild

Félag	Leikir	Sigrar	Töp	Sigur %
KR	1257	799	458	63,6%
Njarðvík	1182	798	384	67,5%
Keflavík	976	672	304	68,9%
Grindavík	896	575	321	64,2%
ÍR	1137	565	572	49,7%
Haukar	843	433	410	51,4%
Tindastóll	836	423	413	50,6%
Valur	856	385	471	45,0%
Stjarnan	440	251	189	57,0%
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	244	112	132	45,9%
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	155	40	115	25,8%
Álftanes	67	33	34	49,3%
KFR	88	33	55	37,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%
Sindri	1	0	1	0,0%
ÍBA	2	0	2	0,0%

Sigrar — heima

Félag	Leikir	Sigrar	Töp	Sigur %
KR	626	443	183	70,8%
Njarðvík	592	428	164	72,3%
Keflavík	488	388	100	79,5%
ÍR	579	337	242	58,2%
Grindavík	448	331	117	73,9%
Haukar	421	252	169	59,9%
Tindastóll	418	247	171	59,1%
Valur	430	217	213	50,5%
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	121	60	61	49,6%
Í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	34	21	13	61,8%
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%
Sindri	1	0	1	0,0%

Sigrar — úti

Félag	Leikir	Sigrar	Töp	Sigur %
Njarðvík	590	370	220	62,7%
KR	631	356	275	56,4%
Keflavík	488	284	204	58,2%
Grindavík	448	244	204	54,5%
ÍR	558	228	330	40,9%
Haukar	422	181	241	42,9%
Tindastóll	418	176	242	42,1%
Valur	426	168	258	39,4%
Stjarnan	220	103	117	46,8%
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	78	18	60	23,1%
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