Write a script that produces the following report: For each instructor, display one line with InstructorID, last name, first name, how many courses the instructor teaches, and a note that is defined as follows: “On leave”, when instructor teaches no courses, “Available for another course”, when instructor teaches only one course, and Nothing otherwise

You have the following table:   MANAGERS (MANAGER_ID, LAST_NAME, FIRST_NAME, DEPARTMENT)   Write a Stored Procedure that returns the last name and first name for all managers in a department with the DEPARTMENT passed in as a parameter.    Answer: To write a stored procedure

The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.

For this portion of the lab design the solution in the following manner: Create a table using a two-dimensional list that stores a Fahrenheit temperature and the equivalent Celsius temperature. Use the following range of Fahrenheit temperatures:Starting at -10 through 100 in increments of 10. Thus, the Fahrenheit temperatures will be:-10, 0, 10, 20, 30, 40, 50…and so on.Display the contents of the list.Similarly create tables/lists for the following, starting at 0 through 100 in increments of 10:Miles to kilometersGallons to litersPounds to kilogramsInches to centimetersDisplay the contents of each listSave the program as firstname_lastname_Lab7a.py where you will replace firstname and lastname with your actual first and last name.