Ask a question from expert

Ask now

Database Module- Assignment

13 Pages272 Words56 Views
   

Added on  2020-04-07

Database Module- Assignment

   Added on 2020-04-07

BookmarkShareRelated Documents
Student ID –Date -Database Assignment Module Tutor –1 | P a g e
Database Module- Assignment_1
ReportQueriesQ-1: select INV_NUMBER, sum(LINE_TOTAL) as 'Line Total' from Line group by INV_NUMBER;2 | P a g e
Database Module- Assignment_2
Q-2:select * from vendor where v_state is null;3 | P a g e
Database Module- Assignment_3
Q-3:select * from 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
|332
|92

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