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 84 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
Excellent


robbielu01

  • Member
  • Posts: 336
Reply 3 on: Yesterday
Great answer, keep it coming :)

 

Did you know?

Amoebae are the simplest type of protozoans, and are characterized by a feeding and dividing trophozoite stage that moves by temporary extensions called pseudopodia or false feet.

Did you know?

The National Institutes of Health have supported research into acupuncture. This has shown that acupuncture significantly reduced pain associated with osteoarthritis of the knee, when used as a complement to conventional therapies.

Did you know?

Immunoglobulin injections may give short-term protection against, or reduce severity of certain diseases. They help people who have an inherited problem making their own antibodies, or those who are having certain types of cancer treatments.

Did you know?

There are more bacteria in your mouth than there are people in the world.

Did you know?

A strange skin disease referred to as Morgellons has occurred in the southern United States and in California. Symptoms include slowly healing sores, joint pain, persistent fatigue, and a sensation of things crawling through the skin. Another symptom is strange-looking, threadlike extrusions coming out of the skin.

For a complete list of videos, visit our video library