I need SQL Quesries for this DATA BASE SQL queries, DO NOT COPY

Write SQL queries to find the requested information from the relations de- fined below. Author(aid : int, name : string, dob : date) Book(bid : int, title : string, aid : int, price : real) Foreign key: aid references Author Customer(cid : int, name : string) Purchase(cid : int, bid : int, when : date) Foreign keys: cid references Customer, bid references Book

1. The name of every author who has a name in common with a customer.

2. The title of each book and the first day it was purchased. Books not purchased should have NULLfor first purchase.

3. The names and the total revenue generated by the top 10 most lucrative authors