logo

Database Assignment Report (Doc)

13 Pages396 Words157 Views
   

Added on  2020-03-28

Database Assignment Report (Doc)

   Added on 2020-03-28

ShareRelated Documents
Student ID –Date -Module Tutor –Database Assignment
Database Assignment Report (Doc)_1
ReportQueriesQ-1: select l.INV_NUMBER InvNo, sum(l.LINE_TOTAL) SumLine from Line l group by INV_NUMBER;
Database Assignment Report (Doc)_2
Q-2:select v.V_Code as CodeVendor, v.V_Name as NameVendor, v.V_Contact as ContactVendor, v.V_Areacode as CodeArea, v.V_Phone as PhoneVendor, v.V_State as StateVendor, v.V_Order as OrderVendor from vendor v where v.v_state is null;
Database Assignment Report (Doc)_3
Q-3:select c.Cus_Code as CodeCustomer, c.Cus_Lname as LastNameCustomer, c.Cus_Fname as FirstNameCustomer, c.Cus_Initial as InitialCustomer, c.Cus_Areacode as AreaCodeCustomer, c.Cus_Phone as PhoneCustomer, c.Cus_Balance as BalanceCustomer from customer c where c.cus_balance>200 and c.cus_balance<300;
Database Assignment Report (Doc)_4

End of preview

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

Related Documents
Database Implementation and Research Activity
|11
|1833
|95

Database Implementation and Research Activity: SQL Queries, NoSQL Features | SEO
|7
|1136
|75

Database Implementation and Research Activity
|5
|676
|401

SQL Query Assignment- Using SQLite
|5
|423
|49

SQL Query Assignment - Using SQLite
|7
|395
|245

Research and SQL Queries
|11
|831
|352