logo

Database Module | Assignment

13 Pages332 Words92 Views
   

Added on  2020-03-28

Database Module | Assignment

   Added on 2020-03-28

ShareRelated Documents
Student ID –Date -Database Assignment Module Tutor –1 | P a g e
Database Module | Assignment_1
ReportQueriesQ-1: select INV_NUMBER InvoiceNumber, round(sum(LINE_TOTAL),2) LineTotal from Line group by INV_NUMBER;2 | P a g e
Database Module | Assignment_2
Q-2:select V_Code VCode, V_Name VName, V_Contact VContact, V_Areacode AreaCode, V_Phone Phone, V_State State, V_Order VOrder from vendor where v_state is null;3 | P a g e
Database Module | Assignment_3
Q-3:select Cus_Code CustCode, Cus_Lname CustLastName, Cus_Fname CustFirstName, Cus_Initial CustInitial, Cus_Areacode CustAreaCode, Cus_Phone CustPhone, Cus_Balance CustBalancefrom customer where cus_balance>200 and cus_balance<300;4 | P a g e
Database Module | Assignment_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
|272
|56

Database Assignment Module
|13
|375
|111

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

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

Structured Query Language (SQL) Assignment
|4
|451
|190