1 СПОСОБ

Задание 1.

select fio,data_rogden,pol,spec,kat_obuch.kat_obucheniya,vuz.uch_zavedenie,mp,gp,mo,gok
from gruz,vuz,kat_obuch
where kat_obuch_k in ('03', '07') and fio like 'М%'
and vuz_k=vuz.cod
and kat_obuch_k=kat_obuch.cod
order by 5,6



Задание 2.

select fio,data_rogden,pol,spec,kat_obuch.kat_obucheniya,vuz.uch_zavedenie,mp,gp,mo,gok
from gruz,vuz,kat_obuch
where gok in ('95', '96') and not(data_rogden='%63')
and vuz_k=vuz.cod
and kat_obuch_k=kat_obuch.cod
order by 6,10



Задание 7.

select fio,data_rogden,family.family_status,pol,spec,kat_obuch.kat_obucheniya,vuz.uch_zavedenie,mp,gp
from gruz,family,kat_obuch,vuz
where gok='94' and spec in ('0101','0201','0401')
and vuz_k=vuz.cod
and kat_obuch_k=kat_obuch.cod
and sem_polog_k=family.cod
order by 5,7



Задание 8.

select fio,family.family_status,pol,spec,kat_obuch.kat_obucheniya,vuz.uch_zavedenie,mp,gp,mo,gok
from gruz,family,kat_obuch,vuz
where kat_obuch_k in ('03', '07') and data_rogden='%66'
and vuz_k=vuz.cod
and kat_obuch_k=kat_obuch.cod
and sem_polog_k=family.cod
order by 5,6



2 СПОСОБ

Задание 9.

select fio,data_rogden,pol,spec,kat_obuch.kat_obucheniya,vuz.uch_zavedenie,mp,gp,mo,gok
from gruz join vuz on vuz_k=vuz.cod
join kat_obuch on kat_obuch_k=kat_obuch.cod
where gok in ('93', '94') and spec between '0401' and '0409'
order by 4,10



Задание 13.

select fio,family.family_status,pol,spec,kat_obuch.kat_obucheniya,vuz.uch_zavedenie,mp,gp,mo,gok
from gruz join family on sem_polog_k=family.cod
join vuz on vuz_k=vuz.cod
join kat_obuch on kat_obuch_k=kat_obuch.cod
where gok in ('93', '95') and data_rogden='%64'
order by 6, 10



Задание 14.

select fio,data_rogden,spec,kat_obuch.kat_obucheniya,vuz.uch_zavedenie,mp,gp,mo,gok
from gruz join vuz on vuz_k=vuz.cod
join kat_obuch on kat_obuch_k=kat_obuch.cod
where kat_obuch_k in ('03', '11') and pol='М'
order by 4,5



Задание 15.

select fio,family.family_status,data_rogden,pol,spec,vuz.uch_zavedenie,mp,gp,mo,gok
from gruz join vuz on vuz_k=vuz.cod
join family on sem_polog_k=family.cod
where kat_obuch_k='03' and gp in ('90', '91')
order by 6,8


















Чтобы не видеть здесь видео-рекламу достаточно стать зарегистрированным пользователем.
Чтобы не видеть никакую рекламу на сайте, нужно стать VIP-пользователем.
Это можно сделать совершенно бесплатно. Читайте подробности тут.