[SQL문제풀기] Number of Shipments Per Month

문제

StrataScratch - Number of Shipments Per Month

StrataScratch

https://platform.stratascratch.com/coding/2056-number-of-shipments-per-month?code_type=3

내가 작성한 정답

MySQL

select date_format(shipment_date,'%Y-%m'), count(shipment_id)
from amazon_shipment
group by date_format(shipment_date,'%Y-%m');

PostgreSQL, Oracle

select to_char(shipment_date,'yyyy-mm'), count(shipment_id)
from amazon_shipment
group by to_char(shipment_date,'yyyy-mm');