Database Module Assignment

Student ID –
Date -
Database Assignment
Module Tutor –
1 | P a g e

Report
Queries
Q-1:
select INV_NUMBER, sum(LINE_TOTAL) as 'InvoiceTotal' from Line group by
INV_NUMBER;
2 | P a g e

Q-2:
select V_Code 'VendorCode', V_Name 'VendorName', V_Contact 'VendorContact',
V_Areacode 'AreaCode',
V_Phone 'VendorPhone', V_State 'VendorState', V_Order 'VendorOrder' from vendor where
v_state is null;
3 | P a g e

Q-3:
select Cus_Code 'CustomerCode', Cus_Lname 'CustomerLastName', Cus_Fname
'CustomerFirstName',
Cus_Initial 'CustomerInitial', Cus_Areacode 'AreaCode', Cus_Phone 'CustomerPhone',
Cus_Balance 'CustomerBalance'
from customer where cus_balance>200 and cus_balance<300;
4 | P a g e