Skip to content

Instantly share code, notes, and snippets.

@dvisockas

dvisockas/sql.sql

Created February 2, 2023 11:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dvisockas/8f814358ab07a9bf5c771729d1f89629 to your computer and use it in GitHub Desktop.
Save dvisockas/8f814358ab07a9bf5c771729d1f89629 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql.sql
select category, reason_code_id, kind, symbol, count(*) as counter from disbursement_payment_request_current_states dprcs
join disbursement_states ds on ds.id = dprcs.state_id and ds.category in ('rejected', 'action_required')
join disbursement_payment_request_state_reason_codes dprsrc on dprsrc.payment_request_state_id = dprcs.payment_request_state_id
join reason_codes rc on rc.id = dprsrc.reason_code_id
group by category, reason_code_id, kind, symbol
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment