Log into SQL Server and access the database engine. Once into SQL Server’ s database engine, select the Northwind database as usual. Part A Northwind Traders deals with a number of suppliers. The Products table includes the supplier ID for each product. Go through the Products table and provide a count of the number of products from each company. The output should show the name of the supplier and a count of the number of products it supplies. As you prepare to create this query, decide which information needs to be displayed – this will be listed in the SELECT clause. Review the tables to determine which tables to use – these will be listed in the FROM clause. This problem will require an aggregate function – which one? What fields will be in the GROUP BY? If more than one table is needed, how will these tables be joined? 1. Using the query window, type the SELECT statement needed to produce the desired results. The SQL is given below and after you’ ve typed your query, click on the Execute button to run the query and see the results. The first rows of your result set should look like this: 2. Open up the Lab 4 Student Answer Sheet located in Doc Sharing, and answer the questions related to this part of the lab. 3. You must provide copies of your SQL statement and / or results. You may be asked to take a screenshot or cut and paste the SQL into the Word document. Follow the instructions on your lab answer sheet.( To take a screenshot, press CTRL-ALT-PRINTSCREEN. Nothing appears to happen on your screen, but this set of keystrokes places a picture of your screen on the clipboard. In Word, just put your mouse where you want the screenshot to go, and then right click and press Paste. The screenshot will appear in your Word document after a few seconds). Part B The“ Orders” and“ Order Details” tables contain the data relating to current invoices. Provide a list showing order ID, order date, and order total( don’ t forget to include the discount). Round the order total to two decimals; display the order date as mm / dd / yyyy( no timestamp).