Show the message date and subject for all emails sent by one of Enron’s CEOs,

Learning Goal: I’m working on a mysql exercise and need an explanation and answer to help me learn.This assignment helps you practice with “joins” using an email dataset. Only “inner joins” will be needed.each task should be performed with a single query.Show the message date and subject for all emails sent by one of Enron’s CEOs, Jeffrey Skilling (email jeff.skilling@enron.com); order by date (earliest first).
Show the email address and recipient type (TO/CC/BCC) for recipients of the message with subject ‘FERC Issues’; do not apply any particular sort to the results.
Show the date and subject, and sender email of the 10 most recent emails sent by anyone with the last name “Williams”.
Show the date, subject, sender email, and all TO recipients of all emails that have a subject with the word “bankruptcy”. Limit results to messages sent between November 1, 2001 and the end of the year (include Nov 1, but do not include Dec 31), and sent from emails that end with ‘@enron.com’. Order by date, newest last.
Show a sorted distinct list of people (firstname, lastname) who ever sent a BCC email to a CEO, President, or Vice President.
Turn in a single SQL file(( I will provide a server to join so you can see the tables ))
Requirements: 5 queries