Able to use most common SQL aggregate functions Flashcards by Edit Lipcsei

{ "@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" } }

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

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

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

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

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

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

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