Answered

Discover the best answers at Westonci.ca, where experts share their insights and knowledge with you. Get detailed answers to your questions from a community of experts dedicated to providing accurate information. Get quick and reliable solutions to your questions from a community of experienced experts on our platform.

with top5 as (select top 5 vendorid, avg(invoicetotal) as avginvoice from invoices group by vendorid order by avginvoice desc) select invoices.vendorid, max(invoices.invoicetotal) as largestinvoice from invoices join top5 on invoices.vendorid

Sagot :

Thank you for trusting us with your questions. We're here to help you find accurate answers quickly and efficiently. We hope this was helpful. Please come back whenever you need more information or answers to your queries. Stay curious and keep coming back to Westonci.ca for answers to all your burning questions.