Word doc formula

Word doc formula - 1) SELECT course_name, department,...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
1) SELECT course_name, department, num_credits FROM courses; 2) SELECT student_name, city, state FROM students; 3) SELECT* FROM courses; 4) SELECT* FROM teachers; 5) SELECT course_name, department, num_credits FROM courses WHERE num_credits=3; 6) SELECT teachers.teacher_name, teachers.salary FROM teachers WHERE (((teachers. [salary])>=30000)); 7) SELECT student_name FROM students WHERE sex='M'; 8) SELECT student_name, address, city, state, zip FROM students WHERE city='Chicago'; 9) SELECT course_name, department, num_credits FROM courses WHERE department = 'Math' AND num_credits >=3; 10) SELECT student_name, sex, city, state FROM students WHERE city='Erie' or state='CT'; 11) SELECT student_name, city, address, zip FROM students WHERE zip between '20000' and '29999' OR city = 'Erie'; 12) SELECT student_name, state FROM students WHERE not (state='IL'); 13) SELECT teacher_name, salary FROM teachers WHERE salary between 30000 and 35000; 14) SELECT student_name, city, state, zip FROM students WHERE zip not between '20000' and
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/19/2012 for the course MIS 101 taught by Professor Mirchandani during the Spring '11 term at Rutgers.

Page1 / 2

Word doc formula - 1) SELECT course_name, department,...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online