SQL

Consider the database table structure shown in the figure. Write a SELECT statement (oompatible with an Oracie RDBMS) that returns the largest credit total for each vendor over all the invoices that belong to that vendor. The list returned should be in order by credit total, from smallest to largest Table: invoices Column Name Data Type invoice id vendor_id invoice_number varchar2(50) invoice date invoice t number(9,2) payment total number(9,2) credit total terms id invoice due date date payment date date Nullable Default Data Constraint date number(9,2) Yes Table: invoice line items Column Name invoice id invoice sequence NUMBER account_number NUMBER line item amt line item description VARCH100) No Nullable Default Data Constraint Data Type NUMBER PK,FK FK NUMBER(9,2)No