LISTING 1: Script That Creates and 
Populates the TempSamples Table

CREATE TABLE TempSamples
( siteid      VARCHAR(10)   NOT NULL PRIMARY KEY,
  temperatures VARCHAR(8000) NOT NULL )
SET NOCOUNT ON
INSERT INTO TempSamples VALUES('A', '20,22,25,25,14')
INSERT INTO TempSamples VALUES('B', '30,33,28')
INSERT INTO TempSamples VALUES('C', '12,10,8,12,12,13,12,14,10,9')
INSERT INTO TempSamples VALUES('D', '-4,-6,-4,-2')