
USE pubs
GO

CREATE TABLE obsoletejobs (
 job_id    SMALLINT NOT NULL,
 job_desc  VARCHAR(50) NOT NULL,
 min_lvl   TINYINT NOT NULL,
 max_lvl   TINYINT NOT NULL
)
GO

-- try it out
DELETE jobs where job_id = 2
GO
DELETE jobs where job_id > 60
GO

SELECT * FROM obsoletejobs
GO
