Need help with sql statements for Intro to Relational Database homework.

1. Based on the ERD below, display the first name, last name and employee initial of anyone whose first name starts with A. (Hint: You will use a Like phrase.)

2. Based on the ERD below, display all columns in the JOB table for those job descriptions that have both analysts and engineers within the description name. (Hint: You will use a Like phrase.)

3. Based on the ERD below, write the SQL statement to display the average hourly job charge for a job.

JOB ASSIGNMENT OB CODE ASSIGN NUM IO?DESCRIPTION ASSIGN DATE OB CHG HOUR PROJ NUM OB LAST UPDATE EMPLOYEE EMP NUM PROJECT ASSIGN JOB EMP NUM PROJ NUM ASSIGN CHG HR EMP LNAME ASSIGN HOURS PROI NAME EMP FNAME ASSIGN CHARGES PROJ VALUE EMP INITIAL PROJ BALANCE EMP HIREDATE EMP NUM IO?CODE EMP YEARS