Exercise 2Create the table below including the fields and data typesUse the Query Editor to execute the following SQL commands1. select first, last, city from empinfo;2. select last, city, age from empinfowhere age > 30;3. select first, last, city, state from empinfowhere first LIKE ‘J%’;4. select * from empinfo;5. select first, last, from empinfowhere last … Continue reading “select statements in the Query editor | My Assignment Tutor”
Exercise 2Create the table below including the fields and data typesUse the Query Editor to execute the following SQL commands1. select first, last, city from empinfo;2. select last, city, age from empinfowhere age > 30;3. select first, last, city, state from empinfowhere first LIKE ‘J%’;4. select * from empinfo;5. select first, last, from empinfowhere last LIKE ‘%s’;6. select first, last, age from empinfowhere last LIKE ‘%illia%’;7. select * from empinfo where first = ‘Eric’;Produce the select statements in the Query editor1. Display the first name and age for everyone that’s in the table.2. Display the first name, last name, and city for everyone that’s notfrom Payson.3. Display all columns for everyone that is over 40 years old.4. Display the first and last names for everyone whose last nameends in an “ay”.5. Display all columns for everyone whose first name equals “Mary”.6. Display all columns for everyone whose first name contains“Mary”.
