Page Comparison

select count(*), postcode
from sales_order_delivery delivery
join sales_order on delivery.sales_order_id = sales_order.id
join sales_order_attribute service on sales_order.id = service.sales_order_id and service.name = 'service'
join sales_order_attribute courier on sales_order.id = courier.sales_order_id and courier.name = 'courier'
where sales_order.created_on > subdate(now(), INTERVAL 1 YEARMONTH)
and courier.value = 'DHL'
and service.value like '%48%'
group by postcode
order by count(*) desc;