1. List the complete Orders table.

2. List the number and name of all customers that are represented by rep 15 and that have a credit limit of $10,000.

3. List the number and name of all customers that are represented by rep 15 or that have a credit limit of $10,000.

4. List order number and Order date of the orders placed by the customer 334.

5. List the numbers, names and complete address of every customer located on a street that contain the letters Devon.

6. How many customers have a credit limit of $15,000.

7. Find the total of customer balances (in Customer table) whose credit limit is greater than $5000.

8. Give the item number, description, and on-hand value (on-hand * price) for each item in category GME.

9. List the numbers, names, Credit Limit and complete address of every customer with a credit limit between $7500 and $10000. Hint: use BETWEEN operator.

Y Rate