1. Modules must now be classified as either a local module or a national module. Write the SQL that will modify the MODULE table and add a type field for this. By default all modules will need to be classified as national.
2. Write the SQL statements that will do the following
Create a temporary table called Results2008 based on the current result table structure.
Load all records from result into results2008 for assessments issued and received in 2008.
我写了一些,感觉应该是这样的,但是有错误
/*1*/
ALTER TABLE MODULE
ALTER COLUMN MODULE_TYPE CHAR(15)
SET DEFAULT 'NATIONAL'
CHECK (MODULE_TYPE= NATIONAL OR MODULE_TYPE= LOCAL)
/*2*/
SELECT *
INTO #Results2008
FROM RESULT
WHERE ( select ENROLLMENT.year from ENROLLMENT where year = 2008)大家帮我改改
