SQL HELP from these tables

A. Write an outer join using at least 2 tables and specify a restriction. Make sure the data supports this. You may have to manipulate existing data.

B. Use NVL2, SOUNDEX, or CASE in a query.

C. Write a sub-query with 2 inner queries.

C ID |$ C LASTS: C FIRST )? C MI C STATES. C ZIP |?C DPHONE C EPHONE 3.C USERID |?C PASSWORD )? C BIRTHDATE: C ADDRESS 10-DEC-67 9815 Circle Dr Tallahassee FL 14-AUG-58 172 Alto Park 12-APR-60 C_CITY 1 Graham Neal 2 Sanchez Myra 3 Smith Lisa 4 Phelp Paul(null) 18-JAN-81 994 Kirkman Rd. Northpoint NY 5 Lewis Sheila A 6 James Thomas E 32308 9045551897 904558599 grahamn barbiecar 42180 4185551791 4185556643 sanchezmt qwert5 51875 3075557841 3075559852 smithlm joshua5 11795 4825554788 4825558219 phelpp hold98er 37812 3525554972 352555181l lewissa 125pass 87195 7615553485 7615553319 jamest nokstell Seattle WA 850 East Main Santa AnaCA 30-AUG-78 01-JUN-73 195 College Blvd. Newton 348 Rice Lane GA Radcliff WY