Database Assignment Sample

Student ID –
Date -
Database Assignment

Report
Q 1
select LINNData.INV_NUMBER LINNDataINVNo, sum(LINNData.LINE_TOTAL) as
LINNDataSum from Line LINNData group by LINNData.INV_NUMBER;

Q 2
select VENData.V_Code, VENData.V_Name, VENData.V_Contact, VENData.V_Areacode,
VENData.V_Phone, VENData.V_State, VENData.V_Order
from vendor VENData where VENData.v_state is null;

Q 3
select CSMData.Cus_Code CSMDatacode, CSMData.Cus_Lname CSMDatalname,
CSMData.Cus_Fname CSMDatafname,
CSMData.Cus_Initial CSMDataInitial, CSMData.Cus_Areacode CSMDataArea,
CSMData.Cus_Phone CSMDataPhone,
CSMData.Cus_Balance CSMDataBalance from customer CSMData where
CSMData.cus_balance>200 and CSMData.cus_balance<300;