{ "@context": "https://schema.org", "@type": "Organization", "name": "Brainscape", "url": "https://www.brainscape.com/", "logo": "https://www.brainscape.com/pks/images/cms/public-views/shared/Brainscape-logo-c4e172b280b4616f7fda.svg", "sameAs": [ "https://www.facebook.com/Brainscape", "https://x.com/brainscape", "https://www.linkedin.com/company/brainscape", "https://www.instagram.com/brainscape/", "https://www.tiktok.com/@brainscapeu", "https://www.pinterest.com/brainscape/", "https://www.youtube.com/@BrainscapeNY" ], "contactPoint": { "@type": "ContactPoint", "telephone": "(929) 334-4005", "contactType": "customer service", "availableLanguage": ["English"] }, "founder": { "@type": "Person", "name": "Andrew Cohen" }, "description": "Brainscape’s spaced repetition system is proven to DOUBLE learning results! Find, make, and study flashcards online or in our mobile app. Serious learners only.", "address": { "@type": "PostalAddress", "streetAddress": "159 W 25th St, Ste 517", "addressLocality": "New York", "addressRegion": "NY", "postalCode": "10001", "addressCountry": "USA" } }

Able to use most common SQL aggregate functions Flashcards

(7 cards)

1
Q

COUNT

A

COUNT: This function counts the number of rows in a specified column or table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

SUM

A

SUM: This function calculates the sum of values in a specified column.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

AVG

A

AVG: This function calculates the average of values in a specified column.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

MIN

A

MIN: This function returns the minimum value from a specified column.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

MAX

A

MAX: This function returns the maximum value from a specified column.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

GROUP BY

A

GROUP BY:

  • This clause is used in combination with aggregate functions
  • to group rows based on
    • one or more columns.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

HAVING

A

HAVING: This clause is used

  • to filter the results of a GROUP BY query
  • based on a condition.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly