Research and SQL Queries

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

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

Query 2
select custm.cus_lname, sum(invc.inv_total) as 'Total_invoice_value' from customer custm inner join
invoice invc on custm.cus_code=invc.cus_code group by cus_lname;

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