Cоpy-pаste аnd cоmplete the SQL tо creаte a function that given: @BrandName VARCHAR(30) @yearOfInterest INT Returns a table which contains the following columns for the yearOfInterest: UPC_CODE ProdName TotalQtyOrdered (sum of qtyOrdered for that product) TotalRevenue calculated as: sum of (qtyOrdered * unitPrice) - discount$ NOTE: Only include products that had at least 1 order in that year. CREATE FUNCTION udtf_brandYearStats ( @BrandName VARCHAR(30), @yearOfInterest INT)RETURNS TABLEASRETURN( -- Complete the query below: );