Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

eid sname Init job dept dob 2001 Stones S Admin HR 3-12-1980 2002 Johnson K Salesrep Sales 12-4-1991 2003 Nkosi F Manager Accounting 4-6-1978 2004

image text in transcribed

eid sname Init job dept dob 2001 Stones S Admin HR 3-12-1980 2002 Johnson K Salesrep Sales 12-4-1991 2003 Nkosi F Manager Accounting 4-6-1978 2004 Dludla . 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). (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

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

Q: How do you recruit employees?

Answered: 1 week ago