What is all the information about the course INTRODUCTION TO COMPUTER SCIENCE?
select * from course where cname = "INTRODUCTION to computer SCIENCE"
What room is it held in?
select t2.room from course as t1 join department as t2 on t1.dno = t2.dno where t1.cname = "INTRODUCTION to computer SCIENCE"
Also, what is the department name for the department that offers it?
select t2.dname, t2.room from course as t1 join department as t2 on t1.dno = t2.dno where t1.cname = "INTRODUCTION to computer SCIENCE"