Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

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

Databases A Beginners Guide

Authors: Andy Oppel

1st Edition

007160846X, 978-0071608466

More Books

Students also viewed these Databases questions

Question

Describe Table Structures in RDMSs.

Answered: 1 week ago