SELECT p$.$amount, dD$.$districtID, rD$.$ratingID, p$.$payment$\_$id

FROil

sakila.address a$,$

sakila.film f$,$

sakila.payment p$,$

sakila.customer $c,$

sakila.inventory i$,$

sakila.rental r$,$

star$3.$ RatingDim rD$,$

star$3.$ DistrictDim dD

WHERE p$.$customer$\_$id $=$ c$.$customer$\_$id

AND p$.$rental$\_$id $=$ r$.$rental$\_$id

AND r$.$inventory$\_$id $=$ i$.$inventory$\_$id

AND i$.$film$\_$id $=$ f$.$film$\_$id

AND c$.$address$\_$id $=$ a$.$address$\_$id

AND a$.$district $=$ dD$.$district

AND f$.$rating $=$ rD$,$ ratings

edit the select statment to use joins instead of where clause