Bitte eine Übersicht (Order ID, Bestellwert, Datum) aller Click & Collect Bestellungen bei Goebel in 2021
Versandart: Abholung beim Händler – Store Pickup
SELECT
mag2_sales_order.increment_id as 'Bestellnummer',
replace(mag2_sales_order.grand_total,'.',',') as 'Betrag',
mag2_sales_order.created_at as 'Bestelldatum'
FROM mag2_sales_order
WHERE mag2_sales_order.shipping_method LIKE '%storepickup%'
AND mag2_sales_order.store_name like "%Goebel%"
AND mag2_sales_order.status = 'complete'
AND (mag2_sales_order.created_at BETWEEN '2021-01-01 00:00:00' AND '2021-12-31 23:59:59')