how to Write a SQL Statement to display EmployeeID from Table1 and EmployeeName from Table2 a

1. how to Write a SQL Statement to display Claim Number, EmployeeID from Table1 and EmployeeName from Table2 above.


2. Write a SQL Statement to display all the Information from Table1 and Table2 for “GA” state employees.


3. List of all the Claims from Table1 which have more than 1 record in the Table 3.


4. Show the list of all records from Table 1 where the claim numbers exist in the Table 1 but not in the Table 3.


5. Display the Claim Numbers and their most recent Transaction Date from Table 3