I'm getting stuck on these 2 questions in my Intro to SQL. CREATE VIEW Create a VIEW that returns the total number of daily orders placed in July...

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) =...