Crowdly

Add to Chrome

Which query is correct?

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

Which

query is correct?

SELECT

product_type_id, AVG(price) FROM products GROUP BY product_type_id HAVING

AVG(price) > 20;

100%

SELECT

product_type_id, AVG(price) FROM products;

0%

SELECT

product_type_id, AVG(price) FROM products WHERE AVG(price) > 20 GROUP BY

product_type_id;

0%

SELECT product_type_id, AVG(price) FROM products GROUP product_type_id WHERE AVG(price) > 20;

0%

More questions like this

Want instant access to all verified answers on moodle.inthergroup.com?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome

Telegram Instagram TikTok Question Bank

Terms of Use Contact Us