logo

Database Assignment Module

   

Added on  2020-03-16

13 Pages375 Words111 Views
Student ID –Date -Database Assignment Module Tutor –
Database Assignment Module_1
ReportQueriesQ-1: select INV_NUMBER as InvoiceNo, sum(LINE_TOTAL) as SumOfLine from Line group by INV_NUMBER;
Database Assignment Module_2
Q-2:select V_Code as CodeOfVendor, V_Name as NameOfVendor, V_Contact as ContactOfVendor, V_Areacode as CodeOfArea, V_Phone as PhoneOfVendor, V_State as StateOfVendor, V_Order as OrderOfVendor from vendor where v_state is null;
Database Assignment Module_3
Q-3:select Cus_Code as CodeOfCustomer, Cus_Lname as LastNameOfCustomer, Cus_Fname as FirstNameOfCustomer, Cus_Initial as InitialOfCustomer, Cus_Areacode as AreaCodeOfCustomer, Cus_Phone as PhoenOfCustomer, Cus_Balance as BalanceOfCustomer from customer where cus_balance>200 and cus_balance<300;
Database Assignment Module_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Module Assignment
|13
|366
|40

Database Module | Assignment
|13
|332
|92

Database Module- Assignment
|13
|272
|56

Show Sums of Line Totals for Each Invoice
|6
|479
|147

Show sums of line totals for each invoice.. Query:.
|6
|460
|212

Database Management System Assignment
|6
|232
|66