Advertisement
Guest User

Untitled

a guest
Jun 10th, 2019
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.96 KB | None | 0 0
  1. SELECT M1.MEM_NUM, (M1.Lname||', '||M1.Fname) AS "Customer Name", (SELECT COUNT(rental.MEM_NUM) FROM rental WHERE rental.mem_num=m1.mem_num) AS "Games Rented", (SELECT SUM(detailrental.fee) FROM detailrental inner join rental ON rental.rent_num=detailrental.rent_num inner join membership ON rental.mem_num= m1.mem_num ) AS "Rental Fee",(detailrental.RETURN_DATE- detailrental.DUE_DATE)*DETAILRENTAL.daily_late_fee AS "Late Fees",(detailrental.RETURN_DATE- detailrental.DUE_DATE)*DETAILRENTAL.daily_late_fee+(SELECT SUM(detailrental.fee) FROM detailrental inner join rental ON rental.rent_num=detailrental.rent_num inner join membership ON rental.mem_num= m1.mem_num )AS "Total Fees" FROM membership m1 inner join rental ON m1.mem_num=rental.mem_num inner join DETAILRENTAL ON RENTAL.rent_num=DETAILRENTAL.rent_num GROUP BY M1.mem_num, (Lname||', '||Fname), (M1.Lname||', '||M1.Fname), ', ', Fname, (detailrental.RETURN_DATE- detailrental.DUE_DATE)*DETAILRENTAL.daily_late_fee;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement