Temple University

Example 33: Create a new relation with data from an existing relation. Statement: Create a new relation called “Cust” containing the same columns as Customer but only the rows for which the credit limit is $500 or less. The first thing that must be done is to describe the new table using the data definition facilities of SQL. CREATE TABLE Cust ................
................