Query: List the orders which are fulfilled but receipts are not send

Description

Identify instances where orders have been fulfilled but the corresponding receipts have not been sent. This is useful for ensuring all customers receive their receipts and for maintaining accurate records.

Query

Tables used in this query:

• shopify_order

SQL