SUMming values
There is one more function that has to be implemented - function for summing values. For example, we may want to calculate the total revenue for a certain item.
To sum values in column use SUM
function followed by column which values you want to sum. For our abstract example,
123SELECT SUM(revenue) FROM sells WHERE item = 'Sofa'
Please note, that
SUM
function works only with numeric columns.
Swipe to start coding
From the audi_cars
table calculate the total tax
for all RS4 cars.
Lösung
Danke für Ihr Feedback!
single
Fragen Sie AI
Fragen Sie AI
Fragen Sie alles oder probieren Sie eine der vorgeschlagenen Fragen, um unser Gespräch zu beginnen
Awesome!
Completion rate improved to 2.63Awesome!
Completion rate improved to 2.63
SUMming values
There is one more function that has to be implemented - function for summing values. For example, we may want to calculate the total revenue for a certain item.
To sum values in column use SUM
function followed by column which values you want to sum. For our abstract example,
123SELECT SUM(revenue) FROM sells WHERE item = 'Sofa'
Please note, that
SUM
function works only with numeric columns.
Swipe to start coding
From the audi_cars
table calculate the total tax
for all RS4 cars.
Lösung
Danke für Ihr Feedback!
single
Awesome!
Completion rate improved to 2.63
SUMming values
Swipe um das Menü anzuzeigen
There is one more function that has to be implemented - function for summing values. For example, we may want to calculate the total revenue for a certain item.
To sum values in column use SUM
function followed by column which values you want to sum. For our abstract example,
123SELECT SUM(revenue) FROM sells WHERE item = 'Sofa'
Please note, that
SUM
function works only with numeric columns.
Swipe to start coding
From the audi_cars
table calculate the total tax
for all RS4 cars.
Lösung
Danke für Ihr Feedback!