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!"

hi , all tutor please help me one question ?

A bank’s net deposit draina.Is negative if deposits exceed withdrawals.b.Is positive if deposits exceed withdraws.c.Decreases during holiday and vacation periods.d.In unaffected by holiday and vacation periods.e.Fluctuates unpredictably on any given day

which answer is right ?

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Hi all! 

I”m trying to find a well-versed writer who can help me out with four cover letters. I’ve already began drafting the first two (Spanish Translator and Music Director), but still need the other two (Teacher and Substitute Teacher) for possible future opportunities. I’ve attached one of the drafts for your review (it’s not perfect, but it should work).

Thanks in advance for your help!

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Hi 

After reading the attached files 

 please answer the below question and the the answer  should be 2 pages along with citation and references and NO PLAGIARISM 

How should one proceed now to achieve the best possible result for Pharmaz India’s financial services center?

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"