create table course

$($course$\_$id varchar$(8),$

title varchar$(50),$

dept$\_$name varchar$(20),$

credits numeric$(2,0)$ check $($credits $>0),$

primary key $($course$\_$id$),$

constraint course$1$ foreign key $($dept$\_$name$)$ references department$($dept$\_$name$)$

on delete set null

$)$;

create table instructor

$($ID varchar$(5),$

name varchar$(20)$ not null,

dept$\_$name varchar$(20),$

salary numeric$(8,2)$ check $($salary $>29000),$

primary key $($ID$),$

constraint instructor$1$ foreign key $($dept$\_$name$)$ references department$($dept$\_$name$)$

on delete set null

$)$;

create table section

$($course$\_$id varchar$(8),$

sec$\_$id varchar$(8),$

semester varchar$(6)$

check $($semester in $(\text{'}$Fall$\text{'},$ 'Winter', 'Spring', 'Summer'$)),$

year numeric$(4,0)$ check $($year $>1701$ and year $<2100),$

building varchar$(15),$

room$\_$number varchar$(7),$

time$\_$slot$\_$id varchar$(4),$

primary key $($course$\_$id$,$ sec$\_$id$,$ semester, year$),$

constraint section$1$ foreign key $($course$\_$id$)$ references course$($course$\_$id$)$

on delete cascade,

constraint section$2$ foreign key $($building$,$ room$\_$number$)$

references classroom$($building$,$ room$\_$number$)$

on delete set null

$)$;

Referring to and tables. Code an SQL statement that,

Gives the course ID$,$ section, title, semester, building, and room for courses offered in Fall $2023.$ Order the result by course ID and then section.

Copy