1) List the names of all customers that have a credit limit of $7,500 or less.
Name Credit Limit
Als Appliance and Sport $7,500
The Everything Shop $5,000
Lees Sport and Appliance $5,000
Deerfields Four Seasons $7,500
All Season $7,500
1. For each order, list the order number and order date along with the number
and name of the customer that placed the order.
2. For each order placed on October 21, 2007, list the order number along
with the number and name of the customer that placed th
S2 Written Assignment
1. MARINA Table
SHOW COLUMNS FROM marina;
Null Key Default Extra
NO PRI NULL
1. List the names of all customers that have a credit limit of 7, 500.00 or less.
Als Appliance and sport, Fergusons, The Everything Shop, Lees Sport and Appliance, Deerfields Four
Seasons, and All Season.
2. List the order numbers for orders placed by co
S6 Written Assignment
CREATE VIEW MAJOR_CUSTOMER AS
SELECT CUSTOMER_NUM, CUSTOMER_NAME, BALANCE, CREDIT_LIMIT,
WHERE CREDIT_LIMIT <= 10000;
SELECT CUSTOMER_NUM, CUSTOMER_NAME
WHERE BALANCE >