This topic contains a solution. Click here to go to the answer

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

Yolanda

  • Hero Member
  • *****
  • Posts: 757
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



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

mfedorka

  • Sr. Member
  • ****
  • Posts: 324
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

  • Member
  • Posts: 757
Reply 2 on: Jul 7, 2018
Wow, this really help


softEldritch

  • Member
  • Posts: 334
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

 

Did you know?

The modern decimal position system was the invention of the Hindus (around 800 AD), involving the placing of numerals to indicate their value (units, tens, hundreds, and so on).

Did you know?

Nearly 31 million adults in America have a total cholesterol level that is more than 240 mg per dL.

Did you know?

Thyroid conditions may make getting pregnant impossible.

Did you know?

Medication errors are more common among seriously ill patients than with those with minor conditions.

Did you know?

There are more nerve cells in one human brain than there are stars in the Milky Way.

For a complete list of videos, visit our video library