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?
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."
