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