Database Assignment Report - (Doc)

Student ID –
Date -
Database Assignment

Report
Q 1
select LNDetail.INV_NUMBER LNDetailINVNo, sum(LNDetail.LINE_TOTAL) as
LNDetailSum from Line LNDetail group by LNDetail.INV_NUMBER;

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

Q 3
select CSMDetail.Cus_Code CSMDetailcode, CSMDetail.Cus_Lname CSMDetaillname,
CSMDetail.Cus_Fname CSMDetailfname,
CSMDetail.Cus_Initial CSMDetailInitial, CSMDetail.Cus_Areacode CSMDetailArea,
CSMDetail.Cus_Phone CSMDetailPhone,
CSMDetail.Cus_Balance CSMDetailBalance from customer CSMDetail where
CSMDetail.cus_balance>200 and CSMDetail.cus_balance<300;