« previous next »

Author Question: Brackets represent repetitive elements. Indicate whether the statement is true or ... (Read 54 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?

Fungal nail infections account for up to 30% of all skin infections. They affect 5% of the general population—mostly people over the age of 70.

Did you know?

Recent studies have shown that the number of medication errors increases in relation to the number of orders that are verified per pharmacist, per work shift.

Did you know?

Certain rare plants containing cyanide include apricot pits and a type of potato called cassava. Fortunately, only chronic or massive ingestion of any of these plants can lead to serious poisoning.

Did you know?

Pregnant women usually experience a heightened sense of smell beginning late in the first trimester. Some experts call this the body's way of protecting a pregnant woman from foods that are unsafe for the fetus.

Did you know?

Multiple sclerosis is a condition wherein the body's nervous system is weakened by an autoimmune reaction that attacks the myelin sheaths of neurons.

Although the Democrats and the Republicans represent slightly different slices of the center, those ... Although the Democrats and the Republicans represent slightly different slices of the center, those ...
A planar design zirconia oxygen sensor places all of the elements together, which allows the sensor ... A planar design zirconia oxygen sensor places all of the elements together, which allows the sensor ...
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 ...
Anterosuperior view of true pelvis (blue) Anterosuperior view of true pelvis (blue)
Skeletal Elements of Early Reptile Skeletal Elements of Early Reptile
Major bone (tan) and cartilage (light blue) elements of the human skeleton. Inset shows regions of v Major bone (tan) and cartilage (light blue) elements of the human skeleton. Inset shows regions of v
Video: Cardiac conductile cells

For a complete list of videos, visit our video library