SQL statmen: List the first name, the last name, the address, the city, the state, the...

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.

Solutions

Expert Solution

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.

venereology answered 9 months ago

Next > < Previous

Related Solutions

1. Write the SQL code required to list the employee number, first and last name, middle...

1. Write the SQL code required to list the employee number, first and last name, middle initial, and the hire date. Sort your selection by the hire date, to display the newly hired employees first. 2. Modify the previous query and list the employee first, last name and middle initial as one column with the title EMP_NAME. Make sure the names are listed in the following format: First name, space, initial, space, last name (e.g. John T Doe). Hint: use...

Create the following SQL queries using the lyrics database below 1. List the first name, last...

Create the following SQL queries using the lyrics database below 1. List the first name, last name, and region of members who do not have an email. 2. List the first name, last name, and region of members who do not have an email and they either have a homephone ending with a 2 or a 3. 3. List the number of track titles that begin with the letter 's' and the average length of these tracks in seconds 4....

Write the correct code in SQL 1. What is the name and address of the customer...

Write the correct code in SQL 1. What is the name and address of the customer that placed order 57? 2. Assume there is only one product with the description Cherry End Table. List the names of the raw materials that go into making that product. 3. List the product id, description, and finish of the least expensive products. (Note: A couple of rows show a price of 0. Exclude products with a price of 0 from your query.) 4....

Write the correct code in SQL 1. What is the name and address of the customer...

List customer id, customer full name (Last name, full name, state) for those customers that have...

List customer id, customer full name (Last name, full name, state) for those customers that have ordered more than once. List customers (order id, customer id, and customer last name) that had more than 2 -- products in their order. Order your result based on customer id followed by order id SQL SERVER DATABASE

Employee ID First Name Last Name email Title Address Extension Department Department ID Hiring Date Department...

Employee ID First Name Last Name email Title Address Extension Department Department ID Hiring Date Department Phone # 0001 John Smith jsmith Accountant 1300 West st 5775 Accounting 2100 8/1998 407-366-5700 0002 Brian Miller badams Admin Assistant 1552 Palm dr 5367 Human resource 2300 4/1995 407-366-5300 0003 James Miller miller Inventory Manager 2713 Buck rd 5432 Production 2520 8/1998 407-366-5400 0004 John Jackson jackson_sam Sales Person 433 tree dr 5568 Sales 2102 6/1997 407-366-5500 0005 Robert Davis Davis Manager 713...

USE ORACLE - SQL List the name and salary of employees who work for division 3....

USE ORACLE - SQL List the name and salary of employees who work for division 3. List the name of project whose budget is between 5000-7000 List the total number of employee whose initial of name is 's'. (hint, using LIKE operator and wildcard character) List the total number of employee whose initial of name is NOT 's' for each division, including division ID List the total project budget for each division, including division ID. List the ID of the...

IP Address: 37.124.67.99 Subnet Mask: 255.240.0.0 find Network address, Broadcast address, first valid host address, last...

IP Address: 37.124.67.99 Subnet Mask: 255.240.0.0 find Network address, Broadcast address, first valid host address, last valid host address and number of valid hosts in the network. show very clear steps for all the calculations.

Write the pseudocode that prompts the user for their first and last name. Display the first...

Write the pseudocode that prompts the user for their first and last name. Display the first initial of their first name and their last name to the user. Ask the user to input a phone number. The program checks which part of Colorado a phone number is from using the values below. If the second digit of the phone number is one of the below digits, print the phone number and which part of Colorado it is from. If none...

1) Create a table “college” that has as attributes name, city name, state/province/region name, country name,...

1) Create a table “college” that has as attributes name, city name, state/province/region name, country name, and year in which the college was established as well as an ID as primary key. Insert records for 5 colleges of your choice, including one or more you have attended. 2) Create a table “student” that has as attributes first name, last names, and college ID for students, and insert the names of yourself and friends who attended one or more colleges together...

Subjects