Where clause restricts the rows returned by a select

This preview shows page 14 - 17 out of 20 pages.

WHERE clauseRestricts the rows returned by a select statementComparisonconditionsCompares one expression to another value orexpressionTry It / Solve It1. 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' promotionalitem “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 betrademarks of their respective owners.
We have textbook solutions for you!
/Invitation-to-Computer-Science-8th-Edition-9781337561914-1191/
The document you are viewing contains questions related to this textbook.
Chapter 14 / Exercise 4
Invitation to Computer Science
Gersting/Schneider
Expert Verified
Database DesignInstructor Resource Guide4. The following query was supposed to return the CD title "Carpe Diem" but norows were returned. Correct the mistake in the statement and show theoutput.
5. The manager of DJs on Demand would like a report of all the CD titles andyears of CDs that were produced before 2000.
6. Which values will be selected in the following query?
Solution:All will be selectedCopyright © 2013, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may betrademarks of their respective owners.
Database DesignInstructor Resource GuideFor the next three questions, use the following table information:TABLE NAME: studentsCOLUMNS: 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), firstname (fname), and last name (lname) for all students who are female (F) inthe table named students.
8. Write a SQL statement that will display the student number (studentno) of anystudent who has a PE major in the table named students. Title the studentnocolumn Student Number.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 20 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Winter
Professor
toni
Tags
respective owners, Instructor Resource Guide
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Invitation to Computer Science
The document you are viewing contains questions related to this textbook.
Chapter 14 / Exercise 4
Invitation to Computer Science
Gersting/Schneider
Expert Verified

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture