1
Hello, I am relatively new when the subject and database and need to generate a report with the following information,:
Client name
Qty of purchases made by each customer
Total in R$ of each customer’s purchases
Qty of purchases made in the current year of each customer
Total in R$ of purchases in the current year of each customer
Profile photo (photo with ordem_photo = 1)
considering only purchases with the status (sel_status_purchase) completed
with the following tables
table purchases above
itenspurchase table above
table customers above
Pass table schema as text.
– Augusto Vasques