I M Getting Stuck On These 2 Questions In My Intro To Sql Create View Create A V

I’m getting stuck on these 2 questions in my Intro to SQL.#1: CREATE VIEWCreate a VIEW that returns the total number of daily orders placed in July 1996. Display the Number of Orders and the order date.#1: QueryWrite a query that returns the three ship countries with the highest average freight in 1996. List the country and the average freight.

CREATE VIEW vwOrderJul1996ASSELECT OrderDate, COUNT(1) AS [Number of Orders]FROMOrdersGROUP BY OrderDateHaving CONVERT(CHAR(4), OrderDate, 100) = ‘Jul’AND CONVERT(CHAR(4), OrderDate, 120) =…

Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount