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
Get step-by-step solutions from verified subject matter experts
