BIS 345 MENTOR Think Big /bis345mentor.com BIS 345 MENTOR Think Big /bis345mentor.com | Page 29
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
a.
a.
a.
a.
Using Lab 5, provide copies of your SQL Statements, results and reports
for each Section listed below
Part AProduct and Category dataset (7 points)
Paste your SQL Statement here:
Screen print your results and paste here:
Part B: Product and Category report (10 points)
Paste your report here:
Part C: Sales and Territory dataset (10 points)
Paste your SQL Statement here:
Screen print your results and paste here:
Part D: Sales and Territory, report (10 points)
Paste your report here:
Part E: Sales and Territory Report Interpretation (10 points)
Write your interpretation of the results. The interpretation must be a
minimum of one paragraph (3 to 5 well-formed sentences) with no spelling