SQL QUERIES

Description measurementUnit pQty pPrice pDate custPhone R Code Raw Material purchase custName Customer custID sells Supplier saleDate needs Sup ID saleQty emplD Sup_Name Employee sale Price empName Address bakes city Address Phone Num identified_BY cakeType street salary color CT Code building 000009 0000 start_date Cake ingredient CT_description birth_date price CT_name speciality serialNum sales_method CT_code color Find total value of sales done by the shop per each Cake-Type. List the first 5 employees with highest salaries List the 5 highest sold Cake-Type. List the 5 least sold Cake-Type. Show all the employees that are specialized by a certain Cake Type 2. List employees with their total sales amount from highest to lowest