CUSTOMER $($customer$\_$id$,$ store$\_$id$,$ first$\_$name, last$\_$name, email, address, active$)$

RENTAL $($rental$\_$id$,$ rental$\_$date, inventory$\_$id$,$ customer$\_$id$,$ return$\_$date, staff$\_$id$)$

INVENTORY $($inventory$\_$id$,$ film$\_$id$,$ store$\_$id$)$

STORE $($store$\_$id$,$ manager$\_$staff$\_$id$,$ location$)$

STAFF $($staff$\_$id$,$ first$\_$name, last$\_$name, address, email, store$\_$id$,$ salary$)$

PAYMENT $($payment$\_$id$,$ customer$\_$id$,$ staff$\_$id$,$ rental$\_$id$,$ amount, payment$\_$date$)$

FILM $($film$\_$id$,$ title, description, rental$\_$duration, rental$\_$rate$)$

Based on the relations above, construct the SQL statements for:

a$)$

b$)$

c$)$

A list of all film titles, rental duration and their rental rate.