Database: real_estate_rentals
Question: What are the user ids of property owners who have property photos, and how many do each of them have?
SQL:
SELECT T1.owner_user_id ,  count(*) FROM Properties AS T1 JOIN Property_Photos AS T2 ON T1.property_id  =  T2.property_id GROUP BY T1.owner_user_id;