« previous next »

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

About 3% of all pregnant women will give birth to twins, which is an increase in rate of nearly 60% since the early 1980s.

Did you know?

Intradermal injections are somewhat difficult to correctly administer because the skin layers are so thin that it is easy to accidentally punch through to the deeper subcutaneous layer.

Did you know?

The first oncogene was discovered in 1970 and was termed SRC (pronounced "SARK").

Did you know?

Barbituric acid, the base material of barbiturates, was first synthesized in 1863 by Adolph von Bayer. His company later went on to synthesize aspirin for the first time, and Bayer aspirin is still a popular brand today.

Did you know?

The types of cancer that alpha interferons are used to treat include hairy cell leukemia, melanoma, follicular non-Hodgkin's lymphoma, and AIDS-related Kaposi's sarcoma.

The deer mouse and the African elephant represent extremes among mammals of r versus K selection. The deer mouse and the African elephant represent extremes among mammals of r versus K selection.
TrUe....FaLsE TrUe....FaLsE
Elements of critical thinking Elements of critical thinking
Some obesity genes in the human genome. The green triangles represent single genes in which obesity Some obesity genes in the human genome. The green triangles represent single genes in which obesity
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
The problem of repetitive DNA The problem of repetitive DNA
Video: Introduction to Photolithography - WC, BLF, PA, Hard and Soft baking

For a complete list of videos, visit our video library