The OzCo database stores data for a company that sells paint products. The following ERD shows the structure of the database. The company tracks the sale of products to customers. The database keeps data on customers (LGCUSTOMER), sales (LGINVOICE), products (LGPRODUCT), which products are on which invoices (LGLINE), employees (LGEMPLOYEE), the salary history of each employee (LGSALARY_HISTORY), departments (LGDEPARTMENT), product brands (LGBRAND), vendors (LGVENDOR), and which vendors supply each product (LGSUPPLIES).

University/Course: ITEC200

Uploaded: November 5, 2024

Files: 1

✓ Solution:

SOLVED ALL 20 SQL questions.

query 1 :

query 2:

SELECT b.Brand_ID, b.Brand_Name, Format(Avg(p.Prod_Price), “Currency”) AS Average_Price
FROM LGPRODUCT AS p INNER JOIN LGBRAND AS b ON p.Brand_ID = b.Brand_ID
GROUP BY b.Brand_ID, b.Brand_Name
ORDER BY b.Brand_Name;

 

🔒 Whatsapp us for the full file.