Advertisement
Alaricy

Расш. возм. SQL. Урок 7. Подзапросы. задача 3/4

Jan 13th, 2022 (edited)
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.     COUNT (DISTINCT id_transaction) AS transaction_per_day,
  3.     DATE_TRUNC('day', DATE) AS trunc_date
  4. FROM
  5.     transactions
  6. GROUP BY
  7.     trunc_date
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement