ads/CIS495Homework1.pdf CIs 495 KOK HOMEWORK I Name: Using the tables defined in class in CIS database, write the SQL queries for the following questions 1. Count the number of instructors in the CIS department. 2. List the course number and the count of sections for each course that is offered 3. uist the name of all the instructors that are not in CiS department but are teaching CIs100 4. List name and office of each of the member of the Cis department and the number of credits each one teaches 5. List the name(s) and number of sections of any instructor(s) sections. who teachfes) the most number of 6. List the namets) and the number of courses of any inst ructorls) who teach(es) most number of ads/CIS495Homework1.pdf CIs 495 KOK HOMEWORK I Name: Using the tables defined in class in CIS database, write the SQL queries for the following questions 1. Count the number of instructors in the CIS department. 2. List the course number and the count of sections for each course that is offered 3. uist the name of all the instructors that are not in CiS department but are teaching CIs100 4. List name and office of each of the member of the Cis department and the number of credits each one teaches 5. List the name(s) and number of sections of any instructor(s) sections. who teachfes) the most number of 6. List the namets) and the number of courses of any inst ructorls) who teach(es) most number of