Database: real_estate_rentals
Question: How many photos does each property have?
SQL:
SELECT count(*) ,  property_id FROM Property_Photos GROUP BY property_id;