CREATE TABLE Ticker (SYMBOL VARCHAR2(10), tstamp DATE, price NUMBER);
INSERT INTO Ticker VALUES(‘ACME’, DATE ‘2011-04-01’, 12);
INSERT INTO Ticker VALUES(‘ACME’, DATE ‘2011-04-02’, 17);
INSERT INTO Ticker VALUES(‘ACME’, DATE ‘2011-04-03’, 19);
INSERT INTO Ticker VALUES(‘ACME’, DATE ‘2011-04-04’, 21);
INSERT INTO Ticker VALUES(‘ACME’, DATE ‘2011-04-05’, 25);
INSERT INTO Ticker VALUES(‘ACME’, DATE ‘2011-04-06’, 12);
INSERT INTO Ticker VALUES(‘ACME’, DATE ‘2011-04-07’, 15);
INSERT INTO Ticker VALUES(‘ACME’, DATE ‘2011-