Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Lernen SQL Count, Sum, Avg | SQL Aggregate Functions
SQL Tutorial for Beginners

bookSQL Count, Sum, Avg

Similar to the previous chapter, SUM, AVG, and COUNT functions are aggregate functions that return the sum of field, average value, and count. SUM and AVG can be applied only for numbers, and COUNT - for fields of any data type.


              
1

            
SELECT AVG(price) FROM songs
copy

If you want to find the number of records with some condition, you can apply COUNT to the *.

This query outputs the number of records with the release date in the 20th century:


              
12

            
SELECT COUNT(*) FROM songs
WHERE year <= 2000
copy

Aggregate functions and Distinct

If you want to apply aggregate function to the unique values, write DISTINCT inside this function and before the column name:


              
1

            
SELECT COUNT(DISTINCT song) FROM songs
copy
Aufgabe

Swipe to start coding

Now you have to write a query that helps you to calculate the total number of singers. Remember that some singers have two or more records in the table, but you have to pick these singers only once.

Lösung

War alles klar?

Wie können wir es verbessern?

Danke für Ihr Feedback!

Abschnitt 2. Kapitel 3
single

single

Fragen Sie AI

expand

Fragen Sie AI

ChatGPT

Fragen Sie alles oder probieren Sie eine der vorgeschlagenen Fragen, um unser Gespräch zu beginnen

Suggested prompts:

Zusammenfassen Sie dieses Kapitel

Code in file erklären

Erklären, warum file die Aufgabe nicht löst

close

Awesome!

Completion rate improved to 4.17

bookSQL Count, Sum, Avg

Swipe um das Menü anzuzeigen

Similar to the previous chapter, SUM, AVG, and COUNT functions are aggregate functions that return the sum of field, average value, and count. SUM and AVG can be applied only for numbers, and COUNT - for fields of any data type.


              
1

            
SELECT AVG(price) FROM songs
copy

If you want to find the number of records with some condition, you can apply COUNT to the *.

This query outputs the number of records with the release date in the 20th century:


              
12

            
SELECT COUNT(*) FROM songs
WHERE year <= 2000
copy

Aggregate functions and Distinct

If you want to apply aggregate function to the unique values, write DISTINCT inside this function and before the column name:


              
1

            
SELECT COUNT(DISTINCT song) FROM songs
copy
Aufgabe

Swipe to start coding

Now you have to write a query that helps you to calculate the total number of singers. Remember that some singers have two or more records in the table, but you have to pick these singers only once.

Lösung

Switch to desktopWechseln Sie zum Desktop, um in der realen Welt zu übenFahren Sie dort fort, wo Sie sind, indem Sie eine der folgenden Optionen verwenden
War alles klar?

Wie können wir es verbessern?

Danke für Ihr Feedback!

close

Awesome!

Completion rate improved to 4.17
Abschnitt 2. Kapitel 3
single

single

some-alt