Advertisement
Guest User

3.7

a guest
Oct 22nd, 2019
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.54 KB | None | 0 0
  1. SELECT
  2.     *
  3. FROM
  4.     (
  5.     SELECT
  6.         `ОТ`.`No`,
  7.         COUNT(`Код`) AS kol1
  8.     FROM
  9.         (
  10.         SELECT
  11.             `СЛ`.`Код`,
  12.             `СЛ`.`No`,
  13.             COUNT(`ИЖД`.`Код`) AS kol
  14.         FROM
  15.             `СЛ`
  16.         JOIN
  17.             `ИЖД`
  18.         WHERE
  19.             `СЛ`.`Код` = `ИЖД`.`Код`
  20.         GROUP BY
  21.             `СЛ`.`Код`
  22.     ) T1
  23. JOIN
  24.     `ОТ`
  25. ON
  26.     T1.`No` = `ОТ`.`No`
  27. WHERE
  28.     T1.kol = 2
  29. GROUP BY
  30.     `ОТ`.`No`
  31. ) T2
  32. WHERE
  33.     kol1 > 3
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement