Can someone help me write a code for database SQL

Product View Create a view which shows the following details of all products: - The Product Name - Type name - Price (example partial output of the Product View - your data may vary, example illustrates structure only) Favourite Drinks View Create a view which shows the Product ID number, Product Name and Customer email, of all drinks that are in a customer's favourite order. (example partial output of the Favourite Drinks View - your data may vary, example illustrates structure only) Order View Create a view which shows the following details of all deliveries and ordered products. - The Order Id - The Driver Name - The Delivery Date - The Vehicle Make/Model - The ordered product ID number, product name and quantity. - The delivery address. - Any discount percentages (If the order took place during a special event). - The cost of the products (Take into account quantity and discounts)