cs348/a2/a2.sql

select sname, snum from student where year = 2 and snum in
(
  select snum from mark where grade < 65 and deptcode in
  (
    select deptcode from department where deptname = "computer science"
  ) having count(distinct section) > 1
)