SQL>
SQL>
SQL>-------------------------------------------------------------------------------
SQL>-- Fill in your solutions below
SQL>-------------------------------------------------------------------------------
SQL>
SQL>-------------------------------------------------------------------------------
SQL>-- Part 1: SQL - Queries and views
SQL>-------------------------------------------------------------------------------
SQL>
SQL>-- 1 --
SQL>select * from city;
NAME            STATE
=============== ======
Amherst         Mass
Atlanta         Ga
Boston          Mass
Dallas          Tex
Denver          Colo
El Cerrito      Calif
Hickville       Okla
Los Angeles     Calif
Madison         Wisc
New York        NY
Oakland         Calif
Paxton          Ill
Salt Lake City  Utah
San Diego       Calif
San Francisco   Calif
Seattle         Wash
White Plains    Neb
 
                 17 rows found
 
SQL>-- 2 --
SQL>
SQL>-- 3 --
SQL>
SQL>-- 4 --
SQL>
SQL>-- 5 --
SQL>
SQL>-- 6 --
SQL>
SQL>-- 7 --
SQL>
SQL>-- 8 --
SQL>
SQL>-- 9 --
SQL>
SQL>-- 10 --
SQL>
SQL>-- 11 --
SQL>-- create table cheapitems
SQL>-- ...
SQL>
SQL>-- 12 --
SQL>
SQL>-- 13 --
SQL>
SQL>-- 14 --
SQL>
SQL>-- 15 --
SQL>
SQL>-- 16 --
SQL>
SQL>-- 17 --
SQL>
SQL>
SQL>-------------------------------------------------------------------------------
SQL>-- Part 2: Database Integrity - Assertions, Triggers, and Stored Procedures
SQL>-------------------------------------------------------------------------------
SQL>
SQL>-- 1 --
SQL>
SQL>-- 2 --
SQL>
SQL>-- 3 --
SQL>
SQL>-- 4 --
SQL>
SQL>-- 5 --
SQL>
SQL>-- 6 --
SQL>
SQL>
SQL>-- close the log file --
SQL>exit;