Database: real_estate_rentals
Question: Count the number of property photos each property has by id.
SQL:
SELECT count(*) ,  property_id FROM Property_Photos GROUP BY property_id;