Hi!
Na 1::
SQL> alter table COUNTRY
2 add constraint pk_country_id primary key (ID_COUNTRY);

Table altered

Executed in 0.141 seconds

SQL> alter table COUNTRY
2 add constraint uk_country_name unique (COUNTRYNAME);

Table altered

Executed in 0.062 seconds

SQL>
SQL>
SQL> -- Create/Recreate primary, unique and foreign key constraints
SQL> alter table GOODSNAME
2 add constraint pk_goods_id primary key (ID_GOODSNAME);

Table altered

Executed in 0.047 seconds

SQL>
SQL>
SQL> -- Create/Recreate primary, unique and foreign key constraints
SQL> alter table GOODS
2 add constraint fk_goods_country foreign key (ID_COUNTRY)
3 references country (ID_COUNTRY);

Table altered

Executed in 0.047 seconds

SQL> alter table GOODS
2 add constraint fk_goods_id foreign key (ID_GOODS)
3 references goodsname (ID_GOODSNAME);

Table altered

Executed in 0.047 seconds

SQL>
SQL> -- Create/Recreate primary, unique and foreign key constraints
SQL> alter table GOODS
2 add constraint pk_goods primary key (ID_GOODS);

Table altered

Executed in 0.078 seconds

SQL> -- Create/Recreate indexes
SQL> create index goods$goodsname on GOODS (ID_GOODSNAME);

Index created

Executed in 0.031 seconds

SQL> create index goods$firm on GOODS (ID_FIRM);

Index created

Executed in 0.046 seconds

SQL> create index goods$country on GOODS (ID_COUNTRY);

Index created

Executed in 0.093 seconds

SQL>
SQL> select countryname, goodsname, price
2 from
3 (Select a.countryname, c.goodsname, b.price,
4 MAX(b.price) OVER (Partition by b.id_country) AS max_price
5 From country a, goods b, goodsname c
6 where a.id_country = b.id_country
7 and c.id_goodsname = b.id_goodsname)
8 where price = max_price
9 /

COUNTRYNAME GOODSNAME PRICE
-------------------------------------------------- -------------------------------------------------- ---------------------------------------

Executed in 0.047 seconds

Na 2::
Select a.cashname, d.countryname, COUNT(c.id_goods) counter
From CASH a, Orders b, Goods c, Country D
Where a.id_cash = b.id_cash
and d.id_country = c.id_country
and trunc(datetime) >= Trunc( sysdate - 3)
Group by a.cashname, d.countryname
Having COUNT(c.id_goods) >= 5

Na 3::
SELECT DECODE(GROUPING(a.countryname), 1, 'All Countries', a.countryname)
AS Country,
DECODE(GROUPING(b.cashname), 1, 'All Cash', b.cashname)
AS Cash,
DECODE(GROUPING(e.id_goodsname), 1, 'All Goodsname', e.id_goodsname)
AS goods_name,
TO_CHAR(SUM(c.amount), '9,999,999,999') SALES$
FROM Country A, Cash B, Orders C, Goods D, Goodsname E
WHERE
a.id_country = d.id_country
and
b.id_cash = c.id_cash
and
e.id_goodsname = d.id_goodsname
and
c.id_goods = d.id_goods
and trunc(c.datetime) > trunc(sysdate - 3)
GROUP BY CUBE(a.countryname,b.cashname, e.id_goodsname)
Having (Count(e.id_goodsname) > 2);

==========
Kagetsya, tak.... Narod proverit