SQL

Use the CUSTOMER table and ORDERS table.

Write a SQL statement to find the rep number, last name, and first name of each sales rep who represents at least one customer with a credit limit less than $7,000. List each sales rep only once in the results.

Use the REP table and CUSTOMER table.

Write a SQL statement to list the order number and order date placed by the customer named Toys Galore.

0 Tables (Filtered) CUSTOMER I CUSTOMER_NUM 1 CUSTOMER_NAME 1 STREET - CITY 1 STATE 1 POSTAL_CODE 1 BALANCE CREDIT_LIMIT REP_NUM B ITEM ITEM_NUM - DESCRIPTION ION_HAND 1 CATEGORY O STOREHOUSE 1 PRICE ORDER_LINE 1 ORDER_NUM 1 ITEM_NUM 1 NUM_ORDERED - QUOTED_PRICE ORDERS - ORDER_NUM - ORDER_DATE 1 CUSTOMER_NUM REP - REP_NUM LAST_NAME - FIRST_NAME 1 STREET - CITY - STATE - POSTAL_CODE 0 COMMISSION ORATE