Database MYSQL

Database MYSQL
1. Create a query against the flights database (in MySQL) in which you will query the flights table and join it with the planes table. Ensure you have first summarized the flights data by origin, date (year/month/day), tailnum and manufacturer. In other words, for each of those fields the query will show the average delay (arr_delay) and count of flights. Ensure your query retrieves the following fields: origin, aircraft (tailnum), manufacturer, year/month/day, average delay and flight count.

2. Export the query results into CSV

Order from us and get better grades. We are the service you have been looking for.