Félög: Sigrar - karla — Deildarkeppni

Sigrar — heild

Félag	Leikir	Sigrar	Töp	Sigur %
KR	1259	801	458	63,6%
Njarðvík	1184	798	386	67,4%
Keflavík	978	673	305	68,8%
Grindavík	898	576	322	64,1%
ÍR	1139	565	574	49,6%
Haukar	843	433	410	51,4%
Tindastóll	838	425	413	50,7%
Valur	858	387	471	45,1%
Stjarnan	442	251	191	56,8%
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	246	112	134	45,5%
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	157	42	115	26,8%
Álftanes	69	35	34	50,7%
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%
ÍBA	2	0	2	0,0%
Sindri	3	0	3	0,0%

Sigrar — heima

Félag	Leikir	Sigrar	Töp	Sigur %
KR	628	445	183	70,9%
Njarðvík	593	428	165	72,2%
Keflavík	489	389	100	79,6%
ÍR	580	337	243	58,1%
Grindavík	449	332	117	73,9%
Haukar	421	252	169	59,9%
Tindastóll	419	248	171	59,2%
Valur	431	218	213	50,6%
Stjarnan	221	148	73	67,0%
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	78	23	55	29,5%
Álftanes	35	22	13	62,9%
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	2	0	2	0,0%

Sigrar — úti

Félag	Leikir	Sigrar	Töp	Sigur %
Njarðvík	591	370	221	62,6%
KR	631	356	275	56,4%
Keflavík	489	284	205	58,1%
Grindavík	449	244	205	54,3%
ÍR	559	228	331	40,8%
Haukar	422	181	241	42,9%
Tindastóll	419	177	242	42,2%
Valur	427	169	258	39,6%
Stjarnan	221	103	118	46,6%
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	125	52	73	41,6%
Í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%
Höttur	79	19	60	24,1%
ÍA	100	19	81	19,0%
Fram	63	16	47	25,4%
ÍKF	41	15	26	36,6%
Álftanes	34	13	21	38,2%
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%
Sindri	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