
Error running query: SELECT list expression references column created_at which is neither grouped nor aggregated at [2:5]
SELECT
created_at,
date(created_at) as date,
date_trunc(created_at, month) as month,
date_trunc(created_at, week) as week,
date_trunc(created_at, year) as year
FROM order as t
group by 5,4,3
LIMIT 100
업무중이 쿼리 실행하니 이런 오류가 나왔어요
이해가 되지 않아서 질문드립니다
