Query: Get the total number of orders placed and the total amount spent by a customer

Description

Explore the purchasing behavior of a specific customer by determining the total number of purchases made and the overall amount spent. This can aid in understanding customer loyalty and spending habits, which is crucial for targeted marketing and sales strategies.

Query

Tables used in this query:

• shopify_customer

SQL