In Oracle , the statement used to display employee and client ...

[Yolanda]

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]

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'

[Yolanda]

Excellent

[mcarey591]

Gracias!