« previous next »

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

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

Did you know?

Approximately one in four people diagnosed with diabetes will develop foot problems. Of these, about one-third will require lower extremity amputation.

Did you know?

Pregnant women usually experience a heightened sense of smell beginning late in the first trimester. Some experts call this the body's way of protecting a pregnant woman from foods that are unsafe for the fetus.

Did you know?

Vaccines cause herd immunity. If the majority of people in a community have been vaccinated against a disease, an unvaccinated person is less likely to get the disease since others are less likely to become sick from it and spread the disease.

Did you know?

Not getting enough sleep can greatly weaken the immune system. Lack of sleep makes you more likely to catch a cold, or more difficult to fight off an infection.

Vessels composed of vessel elements in xylem tissue. Vessels composed of vessel elements in xylem tissue.
1–12 Elements essential to animal life and health 1–12 Elements essential to animal life and health
Elements of Experimental Design. Elements of Experimental Design.
Summary of the Elements of a Swedish Massage Session Summary of the Elements of a Swedish Massage Session
The elements of chromatin structure The elements of chromatin structure
How to combine like-terms in expressions containing multi-brackets How to combine like-terms in expressions containing multi-brackets
Video: Stomach peristalsis & Enterogastric reflex

For a complete list of videos, visit our video library