Question: What will GROUP BY do in this query? 1 2 3 SELECT apartment, AVG ( price ) AS apt _ prices FROM rent _ data

What will GROUP BY do in this query?
123
SELECT apartment, AVG(price) AS apt_prices
FROM rent_data
GROUP BY apartment;
1 point
Group together the rent_data by apartment prices
Group together the apartment and rent_data tables
Group the rows in the table by apartment
Group only the rows in the apt_prices table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!