Question: IT 330 Lab 6: Advanced SQL Objectives: 1. Explore more advanced SQL queries. 2. Answer the questions, copy the SQL code, create screenshots, and submit

IT 330 Lab 6: Advanced SQL Objectives: 1. Explore more advanced SQL queries. 2. Answer the questions, copy the SQL code, create screenshots, and submit the results. Submission requirements: For all text and image submissions, use MS Word, which is available to you within the Virtual Desktop Infrastructure (VDI). For all SQL code submissions, use MS Word, which is available to you within VDI. For all diagram submissions, use MS Visio, which is available to you within VDI. o Note: If you need assistance on how to get started with this tool, go to the references section at the end of this document. If the submission is more than one file: 1. Name each item appropriately. a. For example: LAB6-AdvSQL-yourName.vsd, LAB6-Questions-yourName.docx 2. Save each item in a single folder. 3. This folder should also be named appropriately. a. For example: LAB5-yourName 4. Compress the folder. 5. Submit the compressed file in Blackboard. Lab: 1. Write an SQL statement to get the average, maximum, and minimum quantity per order stored in table \"Sales.SalesOrderDetail\

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!