« previous next »

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

Russia has the highest death rate from cardiovascular disease followed by the Ukraine, Romania, Hungary, and Poland.

Did you know?

Green tea is able to stop the scent of garlic or onion from causing bad breath.

Did you know?

In the United States, there is a birth every 8 seconds, according to the U.S. Census Bureau's Population Clock.

Did you know?

Although puberty usually occurs in the early teenage years, the world's youngest parents were two Chinese children who had their first baby when they were 8 and 9 years of age.

Did you know?

Only 12 hours after an egg cell is fertilized by a sperm cell, the egg cell starts to divide. As it continues to divide, it moves along the fallopian tube toward the uterus at about 1 inch per day.

A portion of the periodic table of elements A portion of the periodic table of elements
Example of a patient statement. Example of a patient statement.
Summary of the Elements of a Swedish Massage Session Cont. Summary of the Elements of a Swedish Massage Session Cont.
Common sequence features in integrated retroviruses and other eukaryotic transposable elements Common sequence features in integrated retroviruses and other eukaryotic transposable elements
Using trace elements in carbonate shells to estimate temperature Using trace elements in carbonate shells to estimate temperature
Atoms and Elements Atoms and Elements
Video: Factors that increase metabolic rate and heat production

For a complete list of videos, visit our video library