Question: Create and execute a new query that will list the BusinessEntityID, PersonType, FirstName, MiddleName, and LastName of all the people (Person.Person) whose last name starts

Create and execute a new query that will list the BusinessEntityID, PersonType, FirstName, MiddleName, and LastName of all the people (Person.Person) whose last name starts with an X and whose first name starts with an E or an I or a N and contains exactly 5 characters. Do not include the people who have a NULL for the MiddleName.

this is for SQL

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Hello I need A-V all Query Design SQL form Queen Case Study chapter -3 thank you SQL Server, Oracle Database, and MySQL are available on our Web site at www.pearsonhighered.com/kroenke. If you are...

SQL 1) Using a view for a SELECT statement Using YOUR adventureWorks DBs view [ Sales].[vSalePerson], create a SQL query that returns the following columns for the sales people who have a [salesYTD]...

SQL 1) Using a view for a SELECT statement 3 Marks Using YOUR adventureWorks DBs view [ Sales].[vSalePerson], create a SQL query that returns the following columns for the sales people who have a...

For the Pizza Delivery Shop DB, (see Appendix), write SQL queries to answer each of the following questions. a) List all the last names, phone numbers and zip codes of the customers. b) List...

* Database Systems, Coronel/Morris */ /* Type of SQL : MySQL */ Drop schema if exists sales; Create schema Sales; Use sales; DROP TABLE IF EXISTS vendor; CREATE TABLE VENDOR ( `V_CODE` int not null,...

/* Database Systems, Coronel/Morris */ /* Type of SQL : MySQL */ Drop schema if exists sales; Create schema Sales; Use sales; DROP TABLE IF EXISTS vendor; CREATE TABLE VENDOR ( `V_CODE` int not null,...

Retrieving Information From Adventure Works Use your AdventureWorks database to complete these exercises. 19. List the JobTitles for all supervisors. Include each title only once. Answer #20 Paste...

Management has asked for a list of total year-to-date sales by each salesperson, with the salesperson having the highest dollar sales at the top. Each salesperson should be identified by his or her...

Students did an experiment on Swansea University jet engine. They measured ambient temperature 16 deg C and ambient pressure 1.02 bar, engine RPM 49,042 , thrust 11.1328 N, air flow 23.2031 l/s, fuel...

Find the method of moments estimate for if a random sample of size n is taken from the exponential pdf, f Y (y; ) = e y , y 0.

Write each of these ratios in its simplest form. a 2 : 4 b 18 : 6 c 6 : 9 d 32 : 24

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

Classify delivery styles by type.

Identify tasks and techniques associated with special presentation situations.

Demonstrate the techniques to be used when delivering an effective presentation.