You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
123456 |
- USE ap;
- SELECT vendor_id,ROUND(AVG(invoice_total), 2) AS average_invoice_amount
- FROM invoices
- GROUP BY vendor_id
- HAVING AVG(invoice_total) > 2000
- ORDER BY average_invoice_amount DESC;
|