The cats must be ordered first by breed and second by name. They are about to enter an elevator one by one. When all the cats of the same breed have entered they leave.
Which SQL statement helps to know what the running total weight of the cats is?
Cats:
name varchar
breed varchar
weight float
color varchar
age int

Question

The cats must be ordered first by breed and second by name. They are about to enter an elevator one by one. When all the cats of the same breed have entered they leave.

Which SQL statement helps to know what the running total weight of the cats is?

Cats:

name	varchar
breed	varchar
weight	float
color	varchar
age	int

Answer

SELECT name, breed, SUM(weight) OVER (PARTITION BY breed ORDER BY name) AS running_total_weight FROM cats

Answer

SELECT name, breed, SUM(weight) OVER (ORDER BY name) AS running_total_weight FROM cats

Answer

SELECT name, breed, SUM(weight) OVER (PARTITION BY breed GROUP BY name) AS running_total_weight FROM cats ORDER BY name

Answer

SELECT name, breed, SUM(weight) OVER (PARTITION BY breed) AS running_total_weight FROM cats GROUP BY name

Crowdly

The cats must be ordered first by breed and second by name. They are about to en...

Cats:

Want instant access to all verified answers on moodle.astanait.edu.kz?