( 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
Using Lab 5, provide copies of your SQL Statements, results and reports for each Section listed below Part AProduct and Category dataset( 7 points) a. Paste your SQL Statement here: Screen print your results and paste here: Part B: Product and Category report( 10 points) a. Paste your report here: