Question

SQL statmen: List the first name, the last name, the address, the city, the state, the branchNo, and the email of agents working in the branch B005 and having email addresses ending with extensions different from .com.

Answer 1

SQL Statement

SELECT Employee.FirstName, Employee.LastName, Employee.Address, Employee.City, Employee.State, Employee.BranchNo, Employee.Email
FROM Employee
WHERE (((Employee.BranchNo)="B005") AND (Right([Employee].[Email],4)<>".com"));

I have taken a sample database called "Employee" with the above data fields to demonstrate the above. You can change the database as per your requirement. If the headers are different than in the select statement, please change accordingly.

Sample database

Output after running the above query

Snapshot of the query

Let me know if anything is not clear or you require more information on this.