« previous next »

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

Before a vaccine is licensed in the USA, the Food and Drug Administration (FDA) reviews it for safety and effectiveness. The CDC then reviews all studies again, as well as the American Academy of Pediatrics and the American Academy of Family Physicians. Every lot of vaccine is tested before administration to the public, and the FDA regularly inspects vaccine manufacturers' facilities.

Did you know?

Glaucoma is a leading cause of blindness. As of yet, there is no cure. Everyone is at risk, and there may be no warning signs. It is six to eight times more common in African Americans than in whites. The best and most effective way to detect glaucoma is to receive a dilated eye examination.

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?

Aspirin may benefit 11 different cancers, including those of the colon, pancreas, lungs, prostate, breasts, and leukemia.

Did you know?

In 2010, opiate painkllers, such as morphine, OxyContin®, and Vicodin®, were tied to almost 60% of drug overdose deaths.

A true albino squirrel. Note the pink eyes. A true albino squirrel. Note the pink eyes.
True-color view of Mars seen through NASA's Hubble Space Telescope in 1999 True-color view of Mars seen through NASA's Hubble Space Telescope in 1999
Adapoids and omomyoids had longer snouts and are the first “true” primates. Adapoids and omomyoids had longer snouts and are the first “true” primates.
Memory saver. The part numbers represent components from Radio Shack®. Memory saver. The part numbers represent components from Radio Shack®.
The Elements of Cognition The Elements of Cognition
Three common eukaryotic promoter consensus sequence elements Three common eukaryotic promoter consensus sequence elements
Video: Simple Diffusion - gases and nonpolar compounds transport

For a complete list of videos, visit our video library