Задача по SQL
Посмотрим динамику по неделям. Рассчитайте WAU: количество уникальных покупателей по неделям.
Отобразите в таблице номер недели и WAU. Отсортируйте таблицу по номеру недели в порядке возрастания.
Мой запрос:
SELECT EXTRACT(WEEK FROM date), COUNT(bracelet_id) as cnt
from pizza
WHERE date BETWEEN '2022-01-01' AND '2022-12-31'
Group By EXTRACT(WEEK FROM date)
Order by EXTRACT(WEEK FROM date) ASC;
Запрос выполняется, но выпадает ошибка: "Полученный результат не совпадает с ожидаемым".
UPD
Вопрос решен.
SELECT EXTRACT(WEEK FROM date), COUNT(DISTINCT bracelet_id) as cnt
from pizza
WHERE date BETWEEN '2022-01-01' AND '2022-12-31'
Group By EXTRACT(WEEK FROM date)
Order by EXTRACT(WEEK FROM date) ASC;
SELECT EXTRACT(week FROM date), COUNT(DISTINCT bracelet_id) from pizza
group by EXTRACT(week FROM date)
order by EXTRACT(week FROM date)
SELECT EXTRACT(WEEK FROM date), COUNT(DISTINCT bracelet_id)
FROM pizza
GROUP BY EXTRACT(WEEK FROM date)
ORDER BY EXTRACT(WEEK FROM date)
SELECT EXTRACT(WEEK FROM date) AS week,
COUNT(DISTINCT bracelet_id) AS users
FROM pizza
GROUP BY week
ORDER BY week;
SELECT COUNT (DISTINCT bracelet_id), EXTRACT (WEEK
FROM date) AS WEEK
FROM pizza
WHERE date BETWEEN '2022-01-01' AND '2022-12-31'
GROUP BY EXTRACT (WEEK
FROM date)
ORDER BY WEEK ASC;