sql queries list

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 SQL Queries 1. List the names of all employees and their details. 2. List the purchases(s) and their associated row materials and suppliers between certain dates. 3. List the sales(s) and their associated customers and Cake-Type and the employee who sold the cake. 4. Find total value of sales done by the shop 5. Find total value of sales done by the shop per each Cake-Type. 6. List the first 5 employees with highest salaries 7. List the 5 highest sold Cake-Type. 8. List the 5 least sold Cake-Type. 9. Show all the employees that are specialized by a certain Cake-Type 10. 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)