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; 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 ‘’. 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

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.