« previous next »

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

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?

To maintain good kidney function, you should drink at least 3 quarts of water daily. Water dilutes urine and helps prevent concentrations of salts and minerals that can lead to kidney stone formation. Chronic dehydration is a major contributor to the development of kidney stones.

Did you know?

All adverse reactions are commonly charted in red ink in the patient's record and usually are noted on the front of the chart. Failure to follow correct documentation procedures may result in malpractice lawsuits.

Did you know?

The shortest mature adult human of whom there is independent evidence was Gul Mohammed in India. In 1990, he was measured in New Delhi and stood 22.5 inches tall.

Did you know?

As many as 20% of Americans have been infected by the fungus known as Histoplasmosis. While most people are asymptomatic or only have slight symptoms, infection can progress to a rapid and potentially fatal superinfection.

True-color view of Mars seen through NASA's Hubble Space Telescope in 1999 True-color view of Mars seen through NASA's Hubble Space Telescope in 1999
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
Example of a patient statement. Example of a patient statement.
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 ...
A diagram showing one of Mendel’s crosses. True-breeding strains of pea plants with smooth and ... A diagram showing one of Mendel’s crosses. True-breeding strains of pea plants with smooth and ...
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: Hip Animation

For a complete list of videos, visit our video library