BEST CAKES : BEST cakes is a shop that makes and sells cake. Summary: BEST CAKES shop buys raw ingredients from several suppliers. Employee prepares cakes. Employee sells cakes to a customer. Details: BEST CAKES shop buys raw material from suppliers. Each raw material is described by its unique CODE, description, and measurement unit. The company keeps track of the raw materials purchases from suppliers. Keeping in record the purchase date, purchase quantity, and purchase price. The supplier is identified by Supplier ID, name, address, and Phone number. Each Cake-Type is the finished product that can be baked. Cake-Type has its own Identifying Code, name, description, sales method, colors, raw material ingredients, and sales price. The company keeps track of the quantity each Cake-Type needs from those raw materials. The Cake is the baked Item that can be sold. Each cake is baked by an employee and is identified by its Cake-Type, serial_number , and color. serial_number resets for each Cake-Type. BEST CAKES shop has several employees. Each Employee is identified by ID, name, address (city, street, building), salary, start_date , and Birth of Date. The employee has at least one specialty on Cake-Type. The employee bakes a cake. The employee sells cakes to customer. The company needs to keep records of those sales records including the sales_date , quantity and price_collected. The Customer is identified by CutomerID, name, and Phone number.

1. Find total value of sales done by the shop per each Cake-Type. 2. List the first 5 employees with highest salaries 3. List the 5 highest sold Cake-Type. 4. List the 5 least sold Cake-Type. 5. Show all the employees that are specialized by a certain Cake-Type 6. List employees with their total sales amount from highest to lowest.

Write 5 additional queries that you find useful for this application. The queries should be complex queries easy (include union, intersection, difference)