« previous next »

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

Autoimmune diseases occur when the immune system destroys its own healthy tissues. When this occurs, white blood cells cannot distinguish between pathogens and normal cells.

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?

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.

Did you know?

Excessive alcohol use costs the country approximately $235 billion every year.

Did you know?

Everyone has one nostril that is larger than the other.

Example of Reconciling a Bank Statement Cont. Example of Reconciling a Bank Statement Cont.
Elements of Culture Elements of Culture
The Elements of Cognition The Elements of Cognition
The elements with these exceptions are The elements with these exceptions are
Results of Mendel’s crosses using pea plants. The numbers represent the F2 plants showing a given ... Results of Mendel’s crosses using pea plants. The numbers represent the F2 plants showing a given ...
A Haddon Matrix Identifying Preventive Elements for Motor Vehicle Collisions A Haddon Matrix Identifying Preventive Elements for Motor Vehicle Collisions
Video: Primary and secondary response to infection

For a complete list of videos, visit our video library