« previous next »

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

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

Did you know?

The word drug comes from the Dutch word droog (meaning "dry"). For centuries, most drugs came from dried plants, hence the name.

Did you know?

Calcitonin is a naturally occurring hormone. In women who are at least 5 years beyond menopause, it slows bone loss and increases spinal bone density.

Did you know?

Stevens-Johnson syndrome and Toxic Epidermal Necrolysis syndrome are life-threatening reactions that can result in death. Complications include permanent blindness, dry-eye syndrome, lung damage, photophobia, asthma, chronic obstructive pulmonary disease, permanent loss of nail beds, scarring of mucous membranes, arthritis, and chronic fatigue syndrome. Many patients' pores scar shut, causing them to retain heat.

Did you know?

Opium has influenced much of the world's most popular literature. The following authors were all opium users, of varying degrees: Lewis Carroll, Charles, Dickens, Arthur Conan Doyle, and Oscar Wilde.

Simple transposable elements and their mechanism of transposition Simple transposable elements and their mechanism of transposition
TrUe....FaLsE TrUe....FaLsE
The tarsier is a haplorhine, and may represent an evolutionary bridge between lower and higher prima The tarsier is a haplorhine, and may represent an evolutionary bridge between lower and higher prima
Worldwide Variations in Population and Income Levels Developed countries represent only 18% of the Worldwide Variations in Population and Income Levels Developed countries represent only 18% of the
ELEMENTS OF ARCHITECTURE: The Greek Orders ELEMENTS OF ARCHITECTURE: The Greek Orders
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: Definition of heart rate

For a complete list of videos, visit our video library