Inserting into a Table Answers

Your Insert statements should be similar to: (note: use your own table name that you created)

insert into 
  myemployees_ts0211
(firstname, lastname, 
 title, age, salary)
values ('Jonie', 'Weber', 
        'Secretary', 28, 
        19500.00);

1. Select all columns for everyone in your employee table.

   select * from
   myemployees_ts0211

2. Select all columns for everyone with a salary over 30000.

   select * from
   myemployees_ts0211
   where salary > 30000

3. Select first and last names for everyone that's under 30 years old.

   select firstname, lastname
   from myemployees_ts0211
   where age < 30

4. Select first name, last name, and salary for anyone with "Programmer" in their title.

   select firstname, lastname, salary
   from myemployees_ts0211
   where title LIKE '%Programmer%'

5. Select all columns for everyone whose last name contains "ebe".

   select * from
   myemployees_ts0211
   where lastname LIKE '%ebe%'

6. Select the first name for everyone whose first name equals "Potsy".

   select firstname from
   myemployees_ts0211
   where firstname = 'Potsy'

7. Select all columns for everyone over 80 years old.

   select * from
    
   myemployees_ts0211
    
   
   where age > 80

8. Select all columns for everyone whose last name ends in "ith".

   select * from
   myemployees_ts0211
   where lastname LIKE '%ith'

Back to Inserting into a table