BIS 345 MENTOR Invent Yourself/bis345mentor.com BIS 345 MENTOR Invent Yourself/bis345mentor.com | Page 29

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, you should use a screenshot of the result set as you did in the previous question. The screenshot should show at least the first 10 rows of the results. =========================================================

BIS 345 Week 5 iLab FOR MORE CLASSES VISIT

www. bis345mentor. com