Author Question: In Oracle , the statement used to display employee and client names together with all of the jobs ... (Read 77 times)

Yolanda · **on:** Jul 7, 2018

In Oracle , the statement used to display employee and client names together with all of
the jobs for 3/14/06, sorted alphabetically by client name, would be __________.

Fill in the blanks with correct word

Question 2

In Oracle, the statement used to display client emails and contacts, together with job
dates and times, for the jobs that start at either 8 A.M. or 10 A.M., would be __________.

Fill in the blanks with correct word

mfedorka · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

Select employee.name, client.name From employee, client, job Where client.email = job.email And employee.ssn =
job.ssn And job.date = '3/14/06' Order by client.name

Answer to Question 2

Select client.email, client.contact, job.date, job.timestart, job.timeend From client, job Where client.email = job.email
And job.timestart = '8:00 AM' Or job.timestart = '10:00 AM'