SQLize Online / PHPize Online  /  SQLtest Online

-- SELECT store_id, ROUND(AVG(tt.sum2),2) AS 'avg_customer_payment' -- FROM -- ( -- SELECT store_id, ROUND(AVG(tt2.sum),2) AS 'avg_customer_payment' -- FROM -- ( SELECT store_id, SUM(payment.amount) AS 'sum' FROM payment OUTER JOIN rental ON rental.rental_id = payment.rental_id AND rental.customer_id = payment.customer_id OUTER JOIN staff ON staff.staff_id = rental.staff_id WHERE store_id IS NOT NULL GROUP BY payment.customer_id, store_id ORDER BY 1 -- ) AS tt2 -- GROUP BY store_id -- AS tt -- ORDER BY 1;