Given Hw3 restaurant menu situation, write SQL and dataframe ways (a,b) in jupyter notebook setup to find the dish with the second highest price (not 2ndranked, but 2ndhighest price) of the whole menu...

Given Hw3 restaurant menu situation, write SQL and dataframe ways (a,b) in jupyter notebook setup to find the dish with the second highest price (not 2ndranked, but 2ndhighest price) of the whole menu

Do 1 in SQL and dataframe ways (a,b) but 2ndhighest price in its own category (hint: consider using the methodology in 3 below on your way to final solution)

Use dataframe way to display all dishes (category, dish, price) that is neither the highest nor the lowest in its own category. You can get partial credit if you can show only the prices, but not the dish names or category names. Extra credit if you can show two different ways, one using set difference and the other not.

Given a csv file daily temp readings, with a table having column headings: Day (1 to 356), year, T(temperature), write SQL code and dataframe method (a,b) to find a pair of days in 2019 that are 7 days apart whose T difference is closest to 5 (could be above or below).

*This is hw 3 reference