Задание 2.

select fio,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 sem_polog_k in
(select cod from family
where family_status='холост')
and kat_obuch_k in ('03', '07')
and data_rogden='%65'
order by 4,5

Задание 4.

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 in
(select cod from kat_obuch
where kat_obucheniya='студент')
and gok in ('93', '94')
order by 5,6,10

Задание 6.

select fio,family.family_status,data_rogden,pol,spec,kat_obuch.kat_obucheniya,vuz.uch_zavedenie,gp,gok
from gruz join vuz on vuz_k=vuz.cod
join family on sem_polog_k=family.cod
join kat_obuch on kat_obuch_k=kat_obuch.cod
where kat_obuch_k in
(select cod from kat_obuch
where kat_obucheniya='учащийся' or kat_obucheniya='стажер')
and spec between '0101' and '1099'
order by 5,6,7

Задание 15.

select fio,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 kat_obuch_k in
(select cod from kat_obuch
where kat_obucheniya='студент' or kat_obucheniya='аспирант')
and sem_polog_k='0'
and data_rogden='%65'
order by 4,5

Задание 16.

select fio,family.family_status,spec,kat_obuch.kat_obucheniya,vuz.uch_zavedenie,mp,gp,mo,gok
from gruz join vuz on vuz_k=vuz.cod
join family on sem_polog_k=family.cod
join kat_obuch on kat_obuch_k=kat_obuch.cod
where gok in ('93', '94')
and pol='М'
and data_rogden='%63'
order by 3,5,9

























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