TIME LIMIT!!

Figure 1. Sample SQL table. Only the top 5 hoses of records in the table. Too much Consider that you are registered. Table name Products Questions 1. The part given in Figure 1 is given to a sample table. This table Write the query that returns a fine between the price field and 20. 2. Returns the sum of the prices in the sample table given in Figure 1. write the query. 3. The example table given in Figure 1 is the name of the product (ProductName) with "Chef" Write the query that returns the reference average (Price). 4. The sample table given in Figure 1 is only A new table named tbl_yedek directly add ProductID and ProductName information Create and write the query that says it. 5. Write a Registered Procedure that makes new entries in the example table given in Figure 1. The Stored Procedure you are going to write should take all the information as parameters. Name of the product and Unit fields have varchar (30), Price Age money and other fields of type int Get it is.

Price ProductID Product Name 1 Chais 2 Chang Aniseed Syrup Chef Anton's Cajun Seasoning Chef Anton's Gumbo Mo SupplierID CategoryID Unit 1 10 boxes x 20 bags 1 1 24 - 12 oz bottles 1 2 12 - 550 ml bottles 1 2 48.6oz jars 2 36 boxes 10 22 5 21.35