Skip to content

Instantly share code, notes, and snippets.

@meanother
Created October 14, 2021 19:21
Show Gist options
  • Save meanother/e2271f5d175aee81feeb9d8b28ed566f to your computer and use it in GitHub Desktop.
Save meanother/e2271f5d175aee81feeb9d8b28ed566f to your computer and use it in GitHub Desktop.
select
status as "Статус"
, count(*) as "Кол-во"
from
home.dt_banki_responses
where
date(create_dt) >= '2021-01-01'
group by status
order by 2 desc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment