Hi, any help correcting my query??

/*query to capture the customer name, month and year of payment, and total payment amount for each month by these top 10 paying customers*/

WITH TOP10 (

SELECT c.customer_id, p.payment_date, Sum(p.amount) total_pmt_amount,

CONCAT(first_name,”,last_name) as full_name,

AND DATE_TRUNC(‘month’ between ‘2007-01-01’ AND ‘2007-31-12’)

FROM payment p

JOIN customer c

ON p.customer_id= c.customer_id

GROUP BY 1, 2

ORDER BY TOP10

LIMIT by 10 desc;

i think im missing a second subquery for the date_trunc, right? or can i just modify this one more so it works?

ScholarMatic: Explanation & Answer

Your ready answer from a verified tutor is just a click away for as little as $14.99

---

  

Click Order Now to get 100% Original Answer Customized to your instructions!