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 ).
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 a calculated field and an aggregate function . 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 : 2 . Press the Execute button . A partial result set is displayed below :
3 . Answer the questions under Part B of your Lab Answer Sheet , and paste the first SELECT statement and a screenshot of the result set into a Microsoft Word document . Your SQL must be cut and pasted from your SQL window , and should NOT be a screenshot . However ,