I cannot figure out this problem/question. Can someone help me solve this? I must use use postgreSQL to answer the question. For this problem create a table called instructor_course_nums. Write a...

I cannot figure out this problem/question. Can someone help me solve this?

I must use use postgreSQL to answer the question.

For this problem create a table called instructor_course_nums. Write a procedure that accepts an instructor ID as input. The procedure calculates the total number of course sections taught by that instructor, and adds a tuple to the instructor_course_nums table consisting of the instructors ID number, name, and total courses taught - call these attributes: ID, name, and tot_courses. If the instructor already has an entry in the table, then the procedure makes sure the total number of courses taught in the instructor_course_nums table is up-to-date. You must name your procedure:
__insCourseNumsProc
Where is your last name and is the day of the month
you were born. Below is an example of how I named my procedure:
Morabito_05__insCourseNumsProc

Extracted text: 4. For this problem create a table called instructor_course_nums. Write a procedure that accepts an instructor ID as input. The procedure calculates the total number of course sections taught by that instructor, and adds a tuple to the instructor_course_nums table consisting of the instructors ID number, name, and total courses taught - call these attributes: ID, name, and tot courses. If the instructor already has an entry in the table, then the procedure makes sure the total number of courses taught in the instructor_course_nums table is up-to-date. You must name your procedure: insCourseNumsProc Where is your last name and is the day of the month you were born. Below is an example of how I named my procedure: Morabito 05 insCourseNumsProc