Ch3BQueries - - File name: Ch3BQueries.sql - by J. Chen...

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

View Full Document Right Arrow Icon
-- File name: Ch3BQueries.sql -- by J. Chen 9/1/08 - @ c:\OraData\chapter3BC\northwoods.sql @ c:\OraData\chapter3BC\clearwater.sql @ -- chapter 3B, Figure 3-18; p123 SELECT s_first, s_mi, s_last FROM student; F SELECT * FROM location; F -- chapter 3B, Figure 3-19; p124 SELECT f_rank FROM faculty; F SELECT DISTINCT f_rank FROM faculty; F -- chapter 3B; p125 SELECT f_first, f_mi, f_last, f_rank FROM faculty WHERE f_rank = 'Associate'; W SELECT room FROM location WHERE bldg_code = 'BUS' AND capacity >= 40; A -- chapter 3B, Figure 3-20; p126 SELECT * FROM enrollment WHERE grade IS NULL; W SELECT * FROM enrollment WHERE grade IS NOT NULL; W -- chapter 3B, Figure 3-21; p127 SELECT * FROM enrollment WHERE grade IN ('A', 'B'); W SELECT * FROM enrollment WHERE grade NOT IN ('A', 'B'); W -- chapter 3B, Figure 3-22; p128 SELECT * FROM term WHERE term_desc LIKE '%2006'; W SELECT * FROM term WHERE term_desc LIKE 'Fall%'; W SELECT course_no FROM course WHERE course_no LIKE '%1__';
Background image of page 1

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

View Full DocumentRight Arrow Icon
W -- chapter 3B, Figure 3-23; p130 SELECT bldg_code, room, capacity FROM location WHERE capacity >=40 ORDER BY capacity; O SELECT bldg_code, room, capacity FROM location WHERE capacity >=40
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/26/2010 for the course ITS 26 taught by Professor Jack during the Spring '10 term at Staten Island.

Page1 / 4

Ch3BQueries - - File name: Ch3BQueries.sql - by J. Chen...

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

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