Oracle databases use structured query language (SQL) for writing and querying data. Consider the Table 1...

   

Transcribed Image Text:

Oracle databases use structured query language (SQL) for writing and querying data. Consider the Table 1 below: sname Init Job Table 1: Employees dept HR Sales eid dob 2001 Stones S Admin 3-12-1980 2002 Johnson K Salesrep 12-4-1991 2003 Nkosi F Manager Accounting 4-6-1978 2004 Dludla H Trainer Training 20-6-1985 2005 Dlamini J Manager HR 7-9-1976 2006 Pale K Admin HR 16-3-1997 2007 Peter M Trainer Training 14-4-1969 Office location JHB Midrand Pretoria JHB Pretoria Midrand JHB 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). 1.2 Except for Peter M., display all the workers' names and initials. 1.4 Determine all the employees that does not work for the department of sales. (3 Marks) 1.3 Determine the number of workers born before 1990, as well as their job and dates of birth. (3 Marks) 1.5 Determine all the employees that have people working under them. (3 Marks) (3 Marks) (3 Marks) [Sub Total 15 Marks] Oracle databases use structured query language (SQL) for writing and querying data. Consider the Table 1 below: sname Init Job Table 1: Employees dept HR Sales eid dob 2001 Stones S Admin 3-12-1980 2002 Johnson K Salesrep 12-4-1991 2003 Nkosi F Manager Accounting 4-6-1978 2004 Dludla H Trainer Training 20-6-1985 2005 Dlamini J Manager HR 7-9-1976 2006 Pale K Admin HR 16-3-1997 2007 Peter M Trainer Training 14-4-1969 Office location JHB Midrand Pretoria JHB Pretoria Midrand JHB 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). 1.2 Except for Peter M., display all the workers' names and initials. 1.4 Determine all the employees that does not work for the department of sales. (3 Marks) 1.3 Determine the number of workers born before 1990, as well as their job and dates of birth. (3 Marks) 1.5 Determine all the employees that have people working under them. (3 Marks) (3 Marks) (3 Marks) [Sub Total 15 Marks]

Answer rating: 100% (QA)

The answer provided below has been developed in a clear step by step manner Step 1 We have created a... View the full answer