[SQL문제풀기] 할부는 몇 개월로 해드릴까요

문제

solvesql.com

https://solvesql.com/problems/installment-month/

SQLite

내가 작성한 정답

select payment_installments,
      count(distinct order_id) order_count,
      min(payment_value) min_value,
      max(payment_value) max_value,
      avg(payment_value) avg_value
from olist_order_payments_dataset
where payment_type = 'credit_card'
group by payment_installments;