Create a scalar function called PriceOfGivenRank, which takes an input of integertype. PriceOfGivenRank will first sort products in the descending order of unit prices exactly like RankOfGivenPrice in Q3. Then, PriceOfGivenRank will find the unit price of product(s) whose rank equalsto the input integer and return the unit price. If the input integer does not match any rank in the sorted Products table, it returns -2. For example, because there are four products with a unit price of $18 and they are all ranked to be 40, PriceOfGivenRank(40) should return 18. Because no products is ranked to be 90,PriceOfGivenRank(90) returns -2.In addition to 'create function' statement, your script must also contain threestatements to test PriceOfGivenRank. The first test should display a return ofa valid price, the second should display a return of -0.99, and the last is a special test, which uses a valid output of RankOfGivenPrice that you completed in Q3 as its input and this test displays the output of PriceOfGivenRank.