Which query finds the total weight of cats grouped by age, but only returns those groups with a total weight larger than 12 ordered by age?
Table schema:
name varchar
breed varchar
weight float
color varchar
age int

Question

Which query finds the total weight of cats grouped by age, but only returns those groups with a total weight larger than 12 ordered by age? Table schema:

Answer

SELECT age, SUM(weight) AS total_weight FROM cats GROUP BY age HAVING weight > 12 ORDER BY color

Answer

SELECT age, SUM(weight) AS total_weight FROM cats GROUP BY age HAVING SUM(weight) > 12 ORDER BY age

Answer

SELECT age, weight FROM cats GROUP BY age HAVING weight > 12 ORDER BY age

Answer

SELECT age, SUM(weight) AS total_weight FROM cats GROUP BY age HAVING weight > 12 ORDER BY age

Crowdly

Which query finds the total weight of cats grouped by age, but only returns thos...

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