Research and SQL Queries

Assessment Item 4
Research and SQL Queries
Student ID:
Student Name:
5/24/2019

Report
Part A
Query 1
select v.v_code, v.v_name, count(p.p_code) as NumberofProducts from vendor v
inner join product p on v.v_code=p.v_code group by v.v_code, v.v_name;

Query 2
select c.cus_lname, sum(i.inv_total) as 'Totalinvoicevalue' from customer c inner
join invoice i on c.cus_code=i.cus_code group by cus_lname;

Query 3
select concat(cus_fname,' ' , cus_lname) as Customer_Name ,
count(invoice.cus_code) as NumberOfInvoices from customer inner join invoice on
customer.cus_code=invoice.cus_code group by cus_fname, cus_lname;
Query 4