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 24 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
Great answer, keep it coming :)


ashely1112

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

 

Did you know?

Cucumber slices relieve headaches by tightening blood vessels, reducing blood flow to the area, and relieving pressure.

Did you know?

All adults should have their cholesterol levels checked once every 5 years. During 2009–2010, 69.4% of Americans age 20 and older reported having their cholesterol checked within the last five years.

Did you know?

Historic treatments for rheumatoid arthritis have included gold salts, acupuncture, a diet consisting of apples or rhubarb, nutmeg, nettles, bee venom, bracelets made of copper, prayer, rest, tooth extractions, fasting, honey, vitamins, insulin, snow collected on Christmas, magnets, and electric convulsion therapy.

Did you know?

Many supplement containers do not even contain what their labels say. There are many documented reports of products containing much less, or more, that what is listed on their labels. They may also contain undisclosed prescription drugs and even contaminants.

Did you know?

More than 2,500 barbiturates have been synthesized. At the height of their popularity, about 50 were marketed for human use.

For a complete list of videos, visit our video library