Code: Select all
SELECT ROUND(SUM(amount),2) / (SELECT COUNT(roommate_id)
FROM t_roommates
WHERE room_id = 1)
FROM t_roommates
JOIN t_transactions ON
t_roommates.roommate_id = t_transactions.roommate_id
WHERE room_id = 1
Moderator: General Moderators
Code: Select all
SELECT ROUND(SUM(amount),2) / (SELECT COUNT(roommate_id)
FROM t_roommates
WHERE room_id = 1)
FROM t_roommates
JOIN t_transactions ON
t_roommates.roommate_id = t_transactions.roommate_id
WHERE room_id = 1