Write the SQL command to complete each step.
Create a database with two tables: Customers (Cust_ID, First, Last, Balance, CreditLimit, Rep_ID) and Sales_Rep (Rep_ID, Rep_First, Rep_Last, Per_Hour). For simplicity, use Short text for data type except when you can use currency.
1. List the Cust_IDs and names of all customers.
2. List the Cust_Id and name of every customer represented by sales rep 35.
3. List the number and name of all customers that are represented by sales rep 35 and that have credit limits of $10,000.
4. List the number and names of all customers represented by a rep whose last name starts with Per.
5. Find the total and average balances for all customers
6. List all customer last names whose balance is above the credit limit.
7. Calculate the total weekly wages if all sales reps are working for 40 hrs. per week.
8. Add a new customer (45, Jim, Jones, 4000, 5000, 35)
9. List all customer last names corresponding with the last names of their sales reps, sorted by customer last names in ascending order.
10. Update the customer's last name to Newlywed if the Cust_ID is 282