Advertisement
pqnysekackaya

Объединение запросов

Mar 9th, 2021
218
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.77 KB | None | 0 0
  1. SELECT
  2.     COUNT(SUBQ.name) AS count_name
  3. FROM
  4.     (
  5.     SELECT DISTINCT
  6.         products.name AS name
  7.     FROM
  8.         products
  9.     LEFT JOIN (
  10.         SELECT
  11.             id_product
  12.         FROM
  13.             transactions
  14.         WHERE
  15.             CAST(transactions.date AS date) = '2019-06-01') AS SUBQ1 ON products.id_product = SUBQ1.id_product
  16.     WHERE
  17.         SUBQ1.id_product IS NOT NULL
  18.     UNION
  19.     SELECT DISTINCT
  20.         products.name AS name
  21.     FROM
  22.         products
  23.     LEFT JOIN (
  24.         SELECT
  25.             id_product
  26.         FROM
  27.             transactions
  28.         WHERE
  29.             CAST(transactions.date AS date) = '2019-06-08') AS SUBQ2 ON products.id_product = SUBQ2.id_product
  30.     WHERE
  31.         SUBQ2.id_product IS NOT NULL)
  32. AS SUBQ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement