> > >

SQL MCQs

For a table with the following columns:
product_id, product_name, supplier_id, price
Which of the following queries will give you the supplier with the maximum average price of products?

SELECT supplier_id, avg(price) FROM Products group by supplier_id having avg(price) in (Select max(avg_price) from (Select avg(price) as avg_price from products group by supplier_id))

SELECT supplier_id, max(avg(price)) FROM Products group by supplier_id

SELECT supplier_id, avg(price) FROM Products group by supplier_id having avg(price) in (Select max(avg_price) from (Select avg(price) as avg_price from products))

SELECT supplier_id, avg(price) FROM Products group by supplier_id having avg(price) in (Select max(avg(price) as avg_price from products group by supplier_id))

Answer

Correct Answer:

SELECT supplier_id, avg(price) FROM Products group by supplier_id having avg(price) in (Select max(avg_price) from (Select avg(price) as avg_price from products group by supplier_id))

Explanation:

Note: This Question is unanswered, help us to find answer for this one

SQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it

SQL MCQs

For a table with the following columns:product_id, product_name, supplier_id, priceWhich of the following queries will give you the supplier with the maximum average price of products?

For a table with the following columns:
product_id, product_name, supplier_id, price
Which of the following queries will give you the supplier with the maximum average price of products?