CPT 101 Chapter 6/tutorialoutletdotcom - PowerPoint PPT Presentation

About This Presentation
Title:

CPT 101 Chapter 6/tutorialoutletdotcom

Description:

FOR MORE CLASSES VISIT tutorialoutlet Chapter 6 Exercises To test whether a table has been modified correctly as you do these exercises, you can write and run an appropriate SELECT statement. For each screenshot, I need the SQL code and results. 1.) 2.) Write a SELECT statement that returns these columns: The count of the number of orders in the Orders table The sum of the tax_amount columns in the Orders table Write a SELECT statement that returns one row for each category that has products with these 3.) columns: The category_name column from the Categories table The count of the products in the Products table The list price of the most expensive product in the Products table – PowerPoint PPT presentation

Number of Views:6
Slides: 4
Provided by: davidwa22

less

Transcript and Presenter's Notes

Title: CPT 101 Chapter 6/tutorialoutletdotcom


1
CPT 101 Chapter 6/tutorialoutletdotcom
For more course tutorials visit tutorialoutletdotc
om
2
CPT 101 Chapter 6 Exercises To test whether a
table has been modified correctly as you do these
exercises, you can write and run an appropriate
SELECT
FOR MORE CLASSES VISIT tutorialoutlet     Chapter
6 Exercises To test whether a table has been
modified correctly as you do these exercises, you
can write and run an appropriate SELECT
statement. For each screenshot, I need the SQL
code and results. 1.) 2.) Write a SELECT
statement that returns these columns The count
of the number of orders in the Orders table The
sum of the tax_amount columns in the Orders
table Write a SELECT statement that returns one
row for each category that has products with
these 3.) columns The category_name column from
the Categories table
3
CPT 101 Chapter 6/tutorialoutletdotcom
Write a Comment
User Comments (0)
About PowerShow.com