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

create table custcity (

city char,

snum integer

)

create view citymatch (custcity, salecity)

as select distinct a.city, b.city

from customers a, salespeople b)

create view londoncust

as select * from costomers

create table name (

e1 varchar,

e2 char,

select e1*3 from name

where e2=text

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