NoSQL Database: Key-Value, Document-Based, Column-Based, Graph-Based

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

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

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