Студенты-Программеры

create table ssp (

snum integer,

2 char not null)

create table customers (

snum integer,

2 char,

city char)

select * from ssp

where snum=5

(select snum

from customers

where citi=’(San(Jose’);

)

create table orders (

ordate integer not null,

2 char (5) default ‘hello world ; ) ‘

)

select count(*)

from orders

create table name (

q1 integer not null,

q2 char(10)

)

select * from name

where q1=1;

CREATE TABLE COMPANY (

ID INTEGER NOT NULL,

NAME CHAR(20),

EOTMI INTEGER,

PRIMARY KEY (ID),

I of 2 int,

FOREIGN KEY (ID) references department,

);

create table department (

id integer not null,

name char,

location char,

number integer,

co_id integer

)

CREATE TABLE TABLENAME (

1 VARCHAR NOT NULL;]

2 CHAR DEFAULT ‘Hello world’

3 varchar

yp smallint

CHECK (YP>=1960 AND YEAR_PUBL<1900

PRIMARY KEY (1)

)