NoSQL Database: Types and Uses

Database
Assignm
ent
May 22
201
9
Student ID:
Student name:

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

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