« previous next »

Author Question: Brackets represent repetitive elements. Indicate whether the statement is true or ... (Read 60 times)

james

  • Hero Member
  • *****
  • Posts: 573
on: Jul 7, 2018
Brackets   represent repetitive elements.
 
  Indicate whether the statement is true or false

Question 2

Fully explain the following code:SELECT TutorKey, COUNT(SessionTimeKey) AS Total SessionsFROM SessionGROUP BY TutorKeyHAVING COUNT(SessionTimeKey)<4
 
  What will be an ideal response?


k.lashomb

  • Sr. Member
  • ****
  • Posts: 346
Reply #1 on: Jul 7, 2018
Answer to Question 1

FALSE

Answer to Question 2

The SELECT includes the column TutorKey and the aggregate function COUNT which returns a count of the column SessionTimeKey. Both are from the table Session. Because TutorKey is not a part of the aggregate function it must be included in a GROUP BY clause. The criteria for the query includes an aggregate function and so must use the HAVING key word.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Certain chemicals, after ingestion, can be converted by the body into cyanide. Most of these chemicals have been removed from the market, but some old nail polish remover, solvents, and plastics manufacturing solutions can contain these substances.

Did you know?

Anesthesia awareness is a potentially disturbing adverse effect wherein patients who have been paralyzed with muscle relaxants may awaken. They may be aware of their surroundings but unable to communicate or move. Neurologic monitoring equipment that helps to more closely check the patient's anesthesia stages is now available to avoid the occurrence of anesthesia awareness.

Did you know?

Everyone has one nostril that is larger than the other.

Did you know?

The toxic levels for lithium carbonate are close to the therapeutic levels. Signs of toxicity include fine hand tremor, polyuria, mild thirst, nausea, general discomfort, diarrhea, vomiting, drowsiness, muscular weakness, lack of coordination, ataxia, giddiness, tinnitus, and blurred vision.

Did you know?

The highest suicide rate in the United States is among people ages 65 years and older. Almost 15% of people in this age group commit suicide every year.

Formed elements of blood: erythrocytes, leukocytes (neutrophils, eosinophils, basophils, lymphocytes Formed elements of blood: erythrocytes, leukocytes (neutrophils, eosinophils, basophils, lymphocytes
The fossil record of chimpanzees is sparse. The femur from Kikongo, Uganda (c) may represent a late The fossil record of chimpanzees is sparse. The femur from Kikongo, Uganda (c) may represent a late
The fire triangle and the fire tetrahedron For combustion to occur, three elements must be ... The fire triangle and the fire tetrahedron For combustion to occur, three elements must be ...
How to combine like-terms in expressions containing multi-brackets How to combine like-terms in expressions containing multi-brackets
ELEMENTS OF ARCHITECTURE: Roman Architectural Orders ELEMENTS OF ARCHITECTURE: Roman Architectural Orders
Elements of a phylogenetic tree Elements of a phylogenetic tree
Video: Cardiac Cycle (Part 2 of 4)

For a complete list of videos, visit our video library