You have an orders table and a customers table. Write a query that returns every customer along with their total spend, including customers who have never ordered.

Question

Answer

Stay specific. One example, told well, beats three told fast. Make your decisions visible — what you chose between. End on what changed, for whom.

You have an orders table and a customers table. Write a query that returns every customer along with their total spend, including customers who have never ordered.

Practice more