Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q1 Please provide answers for this SQL database question job Question 1 Oracle databases use structured query language (SQL) for writing and querying data. Consider

image text in transcribed

Q1 Please provide answers for this SQL database question

job Question 1 Oracle databases use structured query language (SQL) for writing and querying data. Consider the Table 1 below: Table 1: Employees eid sname Init dept dob Office location 2001 Stones S Admin HR 3-12-1980 JHB 2002 Johnson Salesrep Sales 12-4-1991 Midrand 2003 Nkosi F Manager Accounting 4-6-1978 Pretoria 2004 Dludla H 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 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. (3 Marks) [Sub Total 15 Marks]

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

What is the most important part of any HCM Project Map and why?

Answered: 1 week ago