Discover the best answers to your questions with the help of IDNLearn.com. Get the information you need from our community of experts who provide accurate and thorough answers to all your questions.
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 using this platform to share and learn. Don't hesitate to keep asking and answering. We value every contribution you make. Thank you for choosing IDNLearn.com. We’re dedicated to providing clear answers, so visit us again for more solutions.
