Database AssignmenDatabase Assignment Module Tutor

Added on - 31 Oct 2019

  • 14

    pages

  • 399

    words

  • 38

    views

  • 0

    downloads

Showing pages 4 of 14
Student ID –Date -Database AssignmentModule Tutor –
Table of ContentsQ 1:.............................................................................................................................................3Q 2:.............................................................................................................................................4Q 3:.............................................................................................................................................5Q 4:.............................................................................................................................................6Q 5:.............................................................................................................................................7Q 6:.............................................................................................................................................8Q 7:.............................................................................................................................................9Q 8:...........................................................................................................................................10Q 9:...........................................................................................................................................11Q 10:.........................................................................................................................................12Q 11:.........................................................................................................................................13Q 12:.........................................................................................................................................14
ReportQ 1:select LINN.INV_NUMBER LINInvoiceNo, sum(LINN.LINE_TOTAL) as LINSum fromLine LINN group by LINN.INV_NUMBER;
Q 2:select Venr.V_Code, Venr.V_Name, Venr.V_Contact, Venr.V_Areacode, Venr.V_Phone,Venr.V_State, Venr.V_Orderfrom vendor Venr where Venr.v_state is null;