What and How. Each task describes what needs to be done; the task requirements have been intentionally written in a sufficiently general way that there are a number of reasonable implementations! When you write server code, consider how you would want to use it in a client application.

You are required to use the specified table from the flights database, and to write server-side code (that is, a view, stored procedure, stored function, or trigger). You should also provide code that shows how you would test your server side-code.

Please submit all of your code in a single .SQL file. You may work with a partner. We'll look at some of your most interesting solutions in the next meetup.

1. Write server-side code that returns the distance between two airports in the airports table. See sample procedure on next page.
2. Write server-side code that returns the information from the flights table needed to analyze the relationship between flight delays and day of week.
3. Write server-side code that returns all of the columns from theflights table, plus a column for apparent_temp. Apparent_temp should be how the temperature feels, when wind chill or heat index is accounted for. You'll need to do some research to find appropriate formulas for wind chill and heat index. You may choose reasonable "approximate formulas" as needed. This might be useful for example if you were looking to compare departure delays based on temperature with departure delays based on apparent temperature.

# Need to run the code in Pgadmin