Sql help?

For questions #7 & 8 below, please use the following ER Diagram for the CD database also previously used. cd.members memid cd.facilities cd.bookings d character vayjing/20) characler vanying/200) umame facd name membercost guestoost ntialoutlay monthlymaintenanoe numenic facid character varying/100 0L mend n address numeri imestamp numenic haracter vayjing/20) lots intege numen ecommendedby integer ate 7. If you'd like to get the signup date of your last member, how can you retrieve this information? No output needed here, just the solution - your SQL statemen. 8. Find all facilities whose name begins with Tennis' regardless of the case-sensitivity and retrieve all columns? No outpuit needed here, just the solution -your SQL statement