Skip to content

Instantly share code, notes, and snippets.

@smalash

smalash/gist:9ebec12f9ebe7ecf6a704a23f1662fb9

Last active May 13, 2021 12:15
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save smalash/9ebec12f9ebe7ecf6a704a23f1662fb9 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save smalash/9ebec12f9ebe7ecf6a704a23f1662fb9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
--Вывести покупателей, у которых было больше 4 попыток оплаты
SELECT * FROM customers
WHERE customerNumber in
(SELECT customerNumber FROM payments
GROUP BY customerNumber
HAVING count(customerNumber)>4)
-- Вывести имена покупателей купивших на payment.amount более 5000, либо product.name 'монитор'
SELECT customerName FROM customers
WHERE customerNumber IN (
SELECT customerNumber
FROM orders
WHERE orderNumber IN (
SELECT orderDetails.orderNumber
FROM products LEFT JOIN orderDetails
ON products.productCode = orderDetails.productCode
WHERE productName = 'монитор'
)
) OR customerNumber IN (
SELECT customers.customerNumber
FROM customers LEFT JOIN payments
ON customers.customerNumber = payments.customerNumber
WHERE payments.amount > 5000
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment