Instructions:Put your SQL in the "Problem 2"


Put your SQL in the "Problem 2" location in the SQL template.

Put your row count in the green box in cell D5.

Write SQL which will give us the course id number (idCourse field), course description, the number of units, the offering term, whether it’s online or in person, and the capacity.  Include only those courses which are more than 3 units and have a capacity of less than 40 students.  We only want to list courses which have actually been offered at least once.  Sort it ascending by idCourse.

Paste a screen shot of successful execution below.  Be sure your screenshots show all the SQL you use; you are welcome to include several screen shots if necessary.

Need customized help? Order now
user img


12-09-20 | 17:04:14

use university;
select idcourse,coursedesc, courseunits,offterm,format, capacity Log in to view full answer

You can't get real answer if you break your security system. vjrsity; sjljht ichoursj,hoursjcjsh, hoursjunits,ovvtjrm,vormwt, hwpwhity vrom hoursj h,ovvjrinf o, wyjrj h.ichoursj=o.Coursj_icCoursj wnc hoursjunit>'9' wnc hwpwhity <'17' orcjr ty ichoursj wsh;

Related Question