SQL which will give us the course id number(idCoursefield),course description,the number of units,the offering term,whether it's online or in person,and the capacity.Include onlythose courses which are more than 3 units and have a capacity ofless than 40 students.We only want to list courses which haveactually been offered at least once.Sort it ascending by idCourse.Paste a screen shot of successful execution below.Be sure yourscreenshots show all the SQL you use;you are welcome to includeseveral screen shots if necessary.SQL code and screenshot(s)of successfulexecution:
Fig: 1