Select vendor_name, count(*) as number_of_invoices, max(invoice_total - payment_total - credit_total) as balance_due from vendors v join invoices i on v. vendor_id = i. vendor_id where invoice_total - payment_total - credit_total > (select avg(invoice_total - payment_total - credit_total) from invoices) group by vendor_name order by balance_due desc

The business cycle is the periodic but irregular up-and-down movement in economic activity, measured by fluctuations in real gross domestic product (gdp) and other macroeconomic variables. a business cycle is typically characterized by four phases—recession, recovery, growth, and decline—that repeat themselves over time. economists note, however, that complete business cycles vary in length. the duration of business cycles can be anywhere from about two to twelve years, with most cycles averaging six years in length. some business analysts use the business cycle model and terminology to study and explain fluctuations in business inventory and other individual elements of corporate operations. but the term "business cycle" is still primarily associated with larger (industry-wide, regional, national, or even international) business trends.

I’ll try to check this out.