Task: return number of courses sections scheduled for each year and semester. P

Task: return number of courses sections scheduled for each year and semester.
Please return year, semester, and number of courses.

Note: This class uses oracle

The query should return something like:

Semester | Year | Number_of_Classes

spring, 2019, 4

winter, 2019. 1

—————————

Schedule table: (scheduled course sections)

sid, — schedule id, unique for each scheduled class section

cid, — class id

snumber, — section number, e.g., 2 means section 2 of the class

semester, — spring, fall, summer, winter,

year, — year of the class

tid, — teach id who teaches this section

num_registered — number of registered students for this class section

—————————

/* Schedule table */
create table schedule(
sid integer,
cid integer,
snumber integer,
semester varchar(10),
year varchar(5),
tid integer,
num_registered integer,
foreign key (cid) references course(cid),
foreign key (tid) references teacher(tid),
primary key (sid));

/
insert into course values (7, 1, ‘IS 420’);

/* Insert into Schedule table */
insert into schedule values (1, 1, 1, ‘winter’, 2019, 1, 29);
insert into schedule values (2, 2, 1, ‘summer’, 2020, 2, 20);
insert into schedule values (3, 3, 2, ‘spring’, 2019, 3, 14);
insert into schedule values (4, 4, 1, ‘fall’, 2019, 4, 23);
insert into schedule values (5, 5, 3, ‘spring’, 2019, 5, 17);
insert into schedule values (6, 6, 1, ‘spring’, 2019, 6, 8);
insert into schedule values (7, 3, 1, ‘spring’, 2019, 3, 7);

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"