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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved