« previous next »

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

Symptoms of kidney problems include a loss of appetite, back pain (which may be sudden and intense), chills, abdominal pain, fluid retention, nausea, the urge to urinate, vomiting, and fever.

Did you know?

Earwax has antimicrobial properties that reduce the viability of bacteria and fungus in the human ear.

Did you know?

Alcohol acts as a diuretic. Eight ounces of water is needed to metabolize just 1 ounce of alcohol.

Did you know?

Long-term mental and physical effects from substance abuse include: paranoia, psychosis, immune deficiencies, and organ damage.

Did you know?

Automated pill dispensing systems have alarms to alert patients when the correct dosing time has arrived. Most systems work with many varieties of medications, so patients who are taking a variety of drugs can still be in control of their dose regimen.

true story true story
Living systems such as the human body consist of closely interrelated elements Living systems such as the human body consist of closely interrelated elements
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 an Explanation of Benefits statement. Example of an Explanation of Benefits statement.
Skeletal Elements of Early Reptile Skeletal Elements of Early Reptile
Mutations in cis-regulatory elements of Ultrabithorax cause homeotic transformations Mutations in cis-regulatory elements of Ultrabithorax cause homeotic transformations
Video: The primary factors that affect circulation - MABP, CO and SVR

For a complete list of videos, visit our video library