Question
Item # Details (unless specified below, all fields are typed to hold string or character values) 1 The SQL statement requesting all columns and all
Item # | Details (unless specified below, all fields are typed to hold string or character values) |
1 | The SQL statement requesting all columns and all rows. The asterisk represents all and there is no limiting value for rows or records, so we get all rows. |
2 | A useful idea of the number of rows or records in the table (91) |
3 | CustomerID is possibly numeric but might just as easily be a character or string value. It is the unique identifier for each customer. This is called the Primary Key (PK). |
4 | CustomerName is the name of the business/organization. |
5 | ContactName is the first and last name of each customer contact person. There may be times when creating a database/table where we separate first name and last name into separate fields. |
6 | Address is the street address. |
7 | City -- you guessed it -- where the business is located (is, of course, part of the address, but is a separate field) |
8 | PostalCode of where the business is located (is, of course, part of the address, but is a separate field) |
9 | Country where the business is located (is, of course, part of the address, but is a separate field) |
1. Use example item #3 above and: a. Create and copy/paste the SQL command to act the very same way but on the Employees table b. How many records (rows) total are in the Employees table? _______ c. Recreate the descriptive table and detail the column names and characteristics 2. Use example item #8 above using OrderDetails and answer: a. How many records are there with 10 or fewer items? ___________ b. Provide a copy/paste of the correct SQL command 3. Using item #8 again, provide a copy/paste of the correct SQL command that displays only the Order ID and Quantity for orders where Quantity is exactly 100
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started