a) Insert 2 more rows of data in the database, with values: 110 Jones Smith K...

  

Transcribed Image Text:

a) Insert 2 more rows of data in the database, with values: 110 Jones Smith K 10-Dec-2000 500 110 Mark Peters W 12-Jan-1990 502. b) Return employee numbers, employee names and employee last name of all the employees with JOB CODE of 500. c) Return all the employee number, first name, and last name of all the employees born after 1-Jan-1995. a) Insert 2 more rows of data in the database, with values: 110 Jones Smith K 10-Dec-2000 500 110 Mark Peters W 12-Jan-1990 502. b) Return employee numbers, employee names and employee last name of all the employees with JOB CODE of 500. c) Return all the employee number, first name, and last name of all the employees born after 1-Jan-1995.