Reference no: EM132231535

Using the table at the bottom, write queries to answer the following questions.

Questions:

1. Display the first name and last name for everyone that lives in Payson.

2. Display the ID and age for everyone who has a last name of Edwards.

3. Display the first name and age for everyone who has a first name that begins with G.

4. Display the first name, last name and age for everyone that is between 30 to 50 years old

5. Display the first name, last name and age for everyone that is less than 30 or greater than 50 years old

6. Display the first and last names of employees who live in Arizona and whose first name starts with E .

7. Display the first and last names of employees who live in Arizona and are greater than 30 years old and whose last name starts with J

Sample Table: empinfo

first last id age city state

John Jones 99980 45 Payson Arizona

Mary Jones 99982 25 Payson Arizona

Eric Edwards 88232 32 San Diego Carlifornia

Mary Edwards 88233 32 Phoenix Arizona

Ginger Howell 98002 42 Cottonwood Arizona

Sebastian Smith 92001 23 Gila Bend Arizona

Gus Gray 22322 35 Bagdad Arizona

Mary May 32326 52 Tucson Arizona

Erica Williams 32327 60 Show Low Arizona

Leroy Brown 32380 22 Pinetop Arizona

Elroy Cleaver 32382 22 Globe Arizona