Where clause restricts the rows returned by a select

WHERE clause Restricts the rows returned by a select statement
Comparison
conditions
Compares one expression to another value or
expression
Try It / Solve It
1. Using the Global Fast Foods database, retrieve the customer’s first name,
last name, and address for the customer who uses ID 456.
2. Show the name, start date, and end date for Global Fast Foods' promotional
item “ballpen and highlighter” giveaway.
3. Create a SQL statement that produces the following output:
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be
trademarks of their respective owners.

Database Design
Instructor Resource Guide
4. The following query was supposed to return the CD title "Carpe Diem" but no
rows were returned. Correct the mistake in the statement and show the
output.
5. The manager of DJs on Demand would like a report of all the CD titles and
years of CDs that were produced before 2000.
6. Which values will be selected in the following query? Solution:
All will be selected
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be
trademarks of their respective owners.

Database Design
Instructor Resource Guide
For the next three questions, use the following table information:
TABLE NAME: students
COLUMNS: studentno NUMBER(6)
fname VARCHAR2(12)
lname VARCHAR(20)
sex CHAR(1)
major VARCHAR2(24)
7. Write a SQL statement that will display the student number (studentno), first
name (fname), and last name (lname) for all students who are female (F) in
the table named students.
8. Write a SQL statement that will display the student number (studentno) of any
student who has a PE major in the table named students. Title the studentno
column Student Number.