Advertisement
Guest User

Untitled

a guest
Nov 18th, 2019
159
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. 1. SELECT sname, grade FROM enroll NATURAL JOIN student WHERE cno = 302;
  2. 2. SELECT dname FROM major NATURAL JOIN student WHERE age < 19 GROUP BY dname;
  3. 3. select cno, sectno from section natural join enroll group by dname, cno, sectno having count(sid) < 10;
  4. 4. select * from enroll where sid = 16;
  5. select grade from enroll where sid = 16 and dname = 'Computer Sciences' and cno = 302 and sectno = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement