What department is the Introduction to Computer Science course in?
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"
Ok, the class will be in Room 224. Do you know who the instructor will be?
select instructor from course as t1 join department as t2 on t1.dno = t2.dno where t1.cname = "INTRODUCTION to computer SCIENCE"
What day is class?
select days from course as t1 join department as t2 on t1.dno = t2.dno where t1.cname = "INTRODUCTION to computer SCIENCE"
How long is the class?
select hours from course as t1 join department as t2 on t1.dno = t2.dno where t1.cname = "INTRODUCTION to computer SCIENCE"
Oh ok, how many credit hours is this course worth?
select credits from course as t1 join department as t2 on t1.dno = t2.dno where t1.cname = "INTRODUCTION to computer SCIENCE"