Question: S Oracle databases use structured query language (SQL) for writing and querying data. Consider the Table 1 below: Table 1: Employees eid sname Init job
S Oracle databases use structured query language (SQL) for writing and querying data. Consider the Table 1 below: Table 1: Employees eid sname Init job dept dob Office location 2001 Stones Admin HR 3-12-1980 JHB 2002 Johnson K Salesrep Sales 12-4-1991 Midrand 2003 Nkosi Manager Accounting 4-6-1978 Pretoria 2004 Dludla Trainer Training 20-6-1985 JHB 2005 Dlamini Manager HR 7-9-1976 Pretoria 2006 Pale K Admin HR 16-3-1997 Midrand 2007 Peter M Trainer Training 14-4-1969 JHB F H J Use the above information and write SQL queries to answer the following questions 1.1 Print a list of all workers, ordered by job and then by age (from young to old). (3 Marks) 1.2 Except for Peter M., display all the workers' names and initials. (3 Marks) 1.3 Determine the number of workers born before 1990, as well as their job and dates of birth. (3 Marks) 1.4 Determine all the employees that does not work for the department of sales. (3 Marks) 1.5 Determine all the employees that have people working under them
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
