For the hw2 database, write a SQL query to find the names of all departments whose department office is in the Robinson building. Your query should be based on the design of the tables, not the sample data. Don't hard-code the query!

For all queries, you may ignore the schema of the hw2 database and treat the "id" fields as "did" for department's key, "cid" as the key of the course table and "sid" as tbe id of the Section table.

------------------------------------//------------------------------------

hw2 database:

create.sql

-- represents college departments

CREATE TABLE solution.department (

id bigserial primary key ,

name varchar(50) not null,

email varchar(50),

building varchar(50) not null,

room varchar(20) not null

);

-- represents courses offered by college departments

CREATE TABLE solution.course (

id bigserial primary key,

name varchar(255) not null,

dept bigint references solution.department not null,

units int not null

);

-- sections of these courses

CREATE TABLE solution.section (

id bigserial primary key,

course bigint references solution.course not null,

term int not null,

yr int not null,

secNum char(2) not null default '01' -- char because lab sections often use letters

);

-----------------------------//--------------------------------------------

insert.sql

-- insert departments

insert into solution.department (name, email, building, room) values ('English', null, 'Music', '2579');

insert into solution.department (name, email, building, room) values ('Computer Science', 'cs@csueastbay.edu', 'Student and Faculty Support', '570');

insert into solution.department (name, email, building, room) values ('Chemistry', 'chem@csueastbay.edu', 'Science', 'North 431');

-- insert some courses

insert into solution.course (name, dept, units) values ('College Writing: Stretch I', 1, 3);

insert into solution.course (name, dept, units) values ('College Writing Lab', 1, 1);

insert into solution.course (name, dept, units) values ('Database Architecture', 2, 3);

insert into solution.course (name, dept, units) values ('Computer Graphics', 2, 3);

insert into solution.course (name, dept, units) values ('Intro to College Chemistry', 3, 3);

-- insert some sections

insert into solution.section (course, term, yr, secnum) values (1, 9, 2020, '01');

insert into solution.section (course, term, yr, secnum) values (1, 5, 2021, '01');

insert into solution.section (course, term, yr, secnum) values (1, 5, 2021, '02');

insert into solution.section (course, term, yr, secnum) values (2, 9, 2020, '01');

insert into solution.section (course, term, yr, secnum) values (2, 5, 2021, '01');

insert into solution.section (course, term, yr, secnum) values (2, 5, 2021, '02');

insert into solution.section (course, term, yr, secnum) values (3, 5, 2021, '01');

insert into solution.section (course, term, yr, secnum) values (3, 5, 2021, '02');

insert into solution.section (course, term, yr, secnum) values (3, 5, 2021, '03');

insert into solution.section (course, term, yr, secnum) values (3, 9, 2020, '01');

insert into solution.section (course, term, yr, secnum) values (4, 9, 2020, '01');

insert into solution.section (course, term, yr) values (5, 9, 2020);