In ShopifyQL, does the operator BETWEEN work in filtering values between a...

cafe_carl

I'm trying to run the following code in ShopifyQL Editor under the Analytics pane in Shopify - FROM sales SHOW order_id, customer_email, shipping_postal_code, shipping_region, product_title, product_variant_title, net_items_sold, net_sales, customer_first_order_date, customer_last_order_date, number_of_orders_per_customer WHERE shipping_postal_code BETWEEN 19100 AND 19200 GROUP BY order_id, customer_email, shipping_postal_code, shipping_region,...

Originally asked by khonshu on Stack Exchange (stackoverflow) (CC BY-SA 4.0).

uphilltech

Good thread on this — worth a read before you pay anyone to build it.

Discussion: https://stackoverflow.com/questions/79741123/in-shopifyql-does-the-operator-between-work-in-filtering-values-between-a-range.

Want it set up for you? UphillTech.