109.     Enter the following data into table Classrooms

 

Classroom

Building

RoomNum

Capacity

1

10

301

40

2

10

302

35

3

10

303

35

4

10

321

20

5

10

320

30

6

11

306

50

7

11

307

45

8

11

308

30

 

 

insert into classrooms values (1,10,'301',40);

insert into classrooms values (2,10,'302',35);

insert into classrooms values (3,10,'303',35);

insert into classrooms values (4,10,'321',20);

insert into classrooms values (5,10,'320',30);

insert into classrooms values (6,11,'306',50);

insert into classrooms values (7,11,'307',45);

insert into classrooms values (8,11,'308',30);: