Write and execute SQL for the following. Use the Northwind sample database. Include the SQL for each problem in your results submitted to your instructor. Do NOT use the MS Access Query By Example (QBE) feature. Actually write the SQL 1. Using the GROUP BY clause and the COUNT function, create a query that will give a count of all the Products, from the Products table, for each Category. In your result set, display the category ID as well as the count. 2. Create a query that willjoin, the Products and Categories tables, and produce a result set with the following columns: from the Products Table from the Products Table from the Products Table from the Categories T from the Products Table ProductID ProductName CategorvId CategoryName UnitPrice able Only include Category Names of: Beverages, and Produce 3. Create a query that will join, the Products and Suppliers tables, and produce a result set with the following columns: ProductID ProductName SupplierID QompanvName from the Products Table from the Products Table from the Products Table from the Suppliers Table from the Suppliers Table ContactName ContactTitlefrom the Suppliers Table Only include Supplier ID 1-4, in your result. Create a query that will join, the Products, Categories, and Suppliers tables, and produce a result set with the following columns: 4. ProductName CategorvName CompanyName from the Products Table from the Products Table from the Categories Table from the Suppliers Table Only include Categories: 1, 4, and 7, in your result