| Team Fly | |
4. Write a SQL statement to select the customer last name, city, state, and amount sold for the customer represented by customer ID 100895.
5. Retrieve a list of all product categories, subcategories, names, and list prices where the list price is greater than $100 while displaying the results for the product category all in uppercase.
6. Rewrite the query from the previous question and round the amount sold so that there are no cents in the display of the list prices.
7. Retrieve a list of all customer IDs and last names where the customer has more than 200 entries in the SALES table.
8. Display the product name of all products that have the lowest list price.
9. Create a view that contains all products in the Electronics category.
10. Sequences provide ________ generated integers.
11. This referential integrity constraint defines the relationship between two tables. Name it.
12. Check constraints enable users to define and enforce rules for:
A. One or more tables
B. No more than one column
C. One or more columns
D. Only one table
13. Deferred constraints are not checked until this statement is issued.
| Team Fly | |