Question: Consider the database table structure shown in the figure Table: invoice line items Column Name invoice id invoice sequence account number line item amt line

Consider the database table structure shown in the figure Table: invoice line items Column Name invoice id invoice sequence account number line item amt line item_description VARCHAR2(100) Data Type NUMBER NUMBER NUMBER NUMBER(9,2) Nullable Default Data Constraint No PK,FK PK FK No No No Table: general_ledger_accounts Column Name account_number number No account description varchar2(50) No Data Type Nullable Default Data Constraint PK UNIQUE Write a SELECT statement (compatible with an Oracle RDBMS) that returns one row for each general ledger account number and that contains two columns: the account description and the sum of the line item amounts in the invoice line items table that have that account number. Be sure and provide column aliases where needed so that both columns of the result set have names
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
