I did all the ones I could, but had trouble coming up with like the last 6 of the SQL statements required. So, I put what the database looks like, and the problems I couldn't figure out into Word....

Ok, well for #2 on that page.. you basically want to join the REP and CUSTOMER tables on the REP_NUM column, and also CUSTOMER.CREDIT_LIMIT = '$10,000.00'. Then just add in the DISTINCT keyword ...

or you could do an inner join.

how would you write that?

well.. a select with a WHERE clause that matches two columns from different tables IS an INNER JOIN (by definition). you can use the following syntax if you like. SELECT DISTINCT(REP_NUM, LAS...