Email: support@prominentessays.com | WhatsApp: +1 (256) 784 58535 | PLACE YOUR FIRST ORDER AND SAVE 15% USING COUPON:

4.8/5

Hi Any Help Correcting My Query

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?

Solution:

15% off for this assignment.

Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!

Why US?

100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

Original Writing

We complete all papers from scratch. You can get a plagiarism report.

Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.