Updating Records Answers

  1. Jonie Weber just got married to Bob Williams. She has requested that her last name be updated to Weber-Williams.

    update 
     myemployees_ts0211
    set lastname=
      'Weber-Williams' 
    where firstname=
          'Jonie' 
     and lastname=
         'Weber';
  2. Dirk Smith's birthday is today, add 1 to his age.

    update myemployees_ts0211
      set age=age+1
      where firstname='Dirk' and lastname='Smith';
  3. All secretaries are now called "Administrative Assistant". Update all titles accordingly.

    update myemployees_ts0211
      set title = 'Administrative Assistant'
      where title = 'Secretary';
  4. Everyone that's making under 30000 are to receive a 3500 a year raise.

    update myemployees_ts0211
      set salary = salary + 3500
      where salary < 30000;
  5. Everyone that's making over 33500 are to receive a 4500 a year raise.

    update myemployees_ts0211
      set salary = salary + 4500
      where salary > 33500;
  6. All "Programmer II" titles are now promoted to "Programmer III".

    update myemployees_ts0211
      set title = 'Programmer III'
      where title = 'Programmer II'
  7. All "Programmer" titles are now promoted to "Programmer II".

    update myemployees_ts0211
      set title = 'Programmer II'
      where title = 'Programmer'

Back to Updating records

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