Database. sql developer

Exercises for joining tables 1. Return th - first name, the last name, and the late fee (s) of each customer. Order the rows by the late fees in descending order, then by the first names in ascending order. Every customer should appear in the output (without having any borrowing too). Use tables borrowing and customers. 2. Return the ID, the last name, and the first name of each author, together with all the corresponding royalties. Only those authors should appear in the output who have atleast one writing. Use tabies authors and writing. 3. Return the first name, the last name, and the membership fee of those customers who have the ame membership fet as the customer whose lask name is " WL11.1ams. Use table custoners. Exercises for using subselects 1. Return the first name, the last name, and the membership fee of those customers who bave the same membership fee as the customer whose last name is "Willians". Use table custonars. ?. Return the first names (each name only once) which both appear in the names of auchocs and customers. Use tables authors and customers. 3. Return the five borrowings having the least late fees. Use table borrowing