SQLite Assignment

Running head: SQLITE ASSIGNMENT
SQLite Assignment
Name of the Student
Name of the University
Author’s note:

1SQLITE ASSIGNMENT
Part A:
Query 1: select vendor.V_CODE, V_NAME, COUNT(P_CODE) AS
NumberOfProducts
From vendor
Inner Join product
On vendor.V_CODE = product.V_CODE
Group By vendor.V_CODE;
Query 2: Select CUS_LNAME, ROUND(SUM(INV_TOTAL), 2) as
Total_invoice_value
From customer
inner join invoice
on customer.CUS_CODE = invoice.CUS_CODE

2SQLITE ASSIGNMENT
group by customer.CUS_CODE;
Query 3: Select CUS_LNAME, Count(INV_TOTAL) as Num_Of_Invoices
From customer
inner join invoice
on customer.CUS_CODE = invoice.CUS_CODE
group by customer.CUS_CODE;
Query 4: Select LINE_UNITS, ROUND(SUM(LINE_PRICE), 2) as 'Total unit price'
from line
Group by LINE_UNITS;