This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: From St,Com where St.Snum = Com.Snum and Dept = 'ECE' Group By St.Snum,City Order By Hours desc; (3) Select St.Snum, Prof.Pnum from St, Prof, Com Where St.Snum = Com.Snum AND Prof.Pnum = Com.Pnum AND St.City <> Prof.City AND St.Dept = Prof.Dept (4) select Snum from St where City = 'Baton Rouge' Union select Prof.Pnum from Com,St,Prof where Com.Snum = St.Snum AND Prof.City = 'Baton Rouge'; (5) select Pnum,Pname from Prof where City = 'Lafayette' AND 3<= ( select count(*) from Com,St,Prof where Prof.Pnum = Com.Pnum AND Prof.Dept = St.Dept AND Com.Snum = St.Snum); (6) Select Snum, Dept From St Where Major_Pnum IN(select Pnum from where Dept = ‘ECE’);...
View Full Document
- Fall '11
- Databases, Foreign key, pnum, dept CHAR