Заполнение данными таблицы Pokupatel_gv

insert into Pokupatel_GV(pasport_dann, familia, adres, telefon)

values(7785553448, 'Ivanov', 'Halturina', 345565);

insert into Pokupatel_GV(pasport_dann, familia, adres, telefon)

values(7697553443, 'Petrov', 'Malanova', 456576);

insert into Pokupatel_GV(pasport_dann, familia, adres, telefon)

values(7643564445, 'Sidoron', 'S_Perovskoy', 453224);

insert into Pokupatel_GV(pasport_dann, familia, adres, telefon)

values(7856588467, 'Makarov', 'Kirova', 766556);

insert into Pokupatel_GV(pasport_dann, familia, adres, telefon)

values(7689545534, 'Dronov', 'Gromova', 545589);

Содержимое таблиц после заполнения

«Изготовитель»

KODFIRMI,"FIRMA","STRANA_IZG"

111,"BMW","Germania"

555,"Dodge","USA"

222,"Mazda","Japan"

333,"VolksVagen","Germania"

444,"HONDA","Japan"

«Автомобиль»

N_DVIG,"N_PRODAJI","KODFIRMI"
343,"3333","333"
454,"4444","444"
121,"1111","111"
232,"2222","222"
565,"5555","555" «Продажа»

N_PRODAJI,"N_DVIG","DATA","KOL","PASPORT_DANN"
2222,"232","10/03/2010","3","7697553443"
4444,"454","10/05/2010","8","7856588467"
1111,"121","10/02/2010","5","7785553448"
3333,"343","10/04/2010","7","7643564445"
5555,"565","10/05/2010","5","7689545534"

«Характеристики»

N_KUZOV,"ZVET","OB_DVIG","MARCA","KUZOV","MOJNOST","N_DVIG"
23456,"kra","6","RX_7","haydj","466","232"
56789,"sin","3","Viper","jaydj","350","565"
34567,"sin","6","Golf","sed","455","343"
12345,"zel","5","X5","sed","500","121"
45678,"jel","2","Civic","sed","400","454" «Покупатель» PASPORT_DANN,"FAMILIA","ADRES","TELEFON" 7697553443,"Petrov","Malanova","456576" 7689545534,"Dronov","Gromova","545589" 7643564445,"Sidoron","S_Perovskoy","453224" 7785553448,"Ivanov","Halturina","345565" 7856588467,"Makarov","Kirova","766556" Выборка данных

Для выборки данных используется команда SELECT.

Пример 1.

Вывести таблицу номеров продаж

select n_prodaji from Prodaja_GV;

N_PRODAJI

----------

1111

2222

3333

4444

5555

Пример 2.

Вывести автомобили с мощностью больше 455

select n_kuzov, mojnost from Harakt_GV where mojnost>455;

N_KUZOV MOJNOST

---------- ----------

12345 500

23456 466

Пример 3.

Вывести данные об объёмах двигателей автомобилей умноженное на 100

Select zvet, ob_dvig*100 from Harakt_GV;

ZVET OB_DVIG*100

-------------------------------------------------- -----------

zel 500

kra 600

sin 600

jel 200

sin 300

Пример 4.

Вывести марки автомобилей, продажи которых составили больше 3

select Harakt_GV.Marca, sum(Prodaja_GV.kol) from Harakt_GV,Prodaja_GV where Harakt_GV.n_dvig = Prodaja_GV.n_dvig group by Harakt_GV.Marca having sum(Prodaja_GV.kol) > 3;

MARCA SUM(PRODAJA_GV.KOL)

-------------------------------------------------- -------------------

Golf 7

X5 5

Civic 8

Viper 5

Пример 5.

Сгруппированные данные о мощности и кузове автомобилей

select mojnost, kuzov from Harakt_GV order by mojnost;

KUZOV

---------

MOJNOST

---------

haydj

350

sed

400

sed

455