Advertisement
Guest User

Untitled

a guest
Oct 19th, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.50 KB | None | 0 0
  1. SELECT m.ID, m.Name, g.MatchID, COUNT(*)
  2. FROM MEMBER m, PLAYER p, GOALS g
  3. WHERE m.ID = p.ID
  4. AND p.ID = g.PlayerID
  5. AND g.MatchID IN
  6. (SELECT DISTINCT n.ID
  7.     FROM TEAM h, `MATCH` n
  8.     WHERE (h.ID = n.HomeTeamID
  9.     OR h.ID = n.AwayTeamID)
  10.     AND n.ID IN (
  11.    SELECT DISTINCT t.`ID`
  12.         FROM PLAYER q, `MATCH` t
  13.         WHERE t.`ID` IN(
  14.             SELECT DISTINCT w.ID
  15.             FROM `MATCH` w
  16.             WHERE w.`HomeTeamID` IN (
  17.                 SELECT e.ID
  18.                 FROM TEAM e, COUNTRY c
  19.                 WHERE e.`Country` = c.`Name`
  20.                 AND e.Country = 'Iceland')
  21.             OR w.AwayTeamID IN (
  22.                 SELECT e.ID
  23.                 FROM TEAM e, COUNTRY c
  24.                 WHERE e.`Country` = c.`Name`
  25.                 AND e.Country = 'Iceland'))))
  26. GROUP BY m.Name
  27. HAVING COUNT(*) = (
  28. (SELECT COUNT(DISTINCT(n.`ID`))
  29.     FROM TEAM h, `MATCH` n
  30.     WHERE (h.ID = n.HomeTeamID
  31.     OR h.ID = n.AwayTeamID)
  32.     AND n.ID IN (
  33.         SELECT DISTINCT t.`ID`
  34.         FROM PLAYER q, `MATCH` t
  35.         WHERE t.`ID` IN(
  36.             SELECT DISTINCT w.ID
  37.             FROM `MATCH` w
  38.             WHERE w.`HomeTeamID` IN (
  39.                 SELECT e.ID
  40.                 FROM TEAM e, COUNTRY c
  41.                 WHERE e.`Country` = c.`Name`
  42.                 AND e.Country = 'Iceland')
  43.             OR w.AwayTeamID IN (
  44.                 SELECT e.ID
  45.                 FROM TEAM e, COUNTRY c
  46.                 WHERE e.`Country` = c.`Name`
  47.                 AND e.Country = 'Iceland')))))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement