create table client(
id number  PRIMARY KEY,
surname varchar2( 50 ),
name varchar2( 50 )
);

create table ADDRESS(
ID number PRIMARY KEY,
city varchar2( 50 ),
address varchar2( 50 )
);

create table ORDER (
ID number PRIMARY KEY,
name varchar2( 50 ),
cnt number,
client_id number,
address_id number
);

ALTER TABLE ORDER ADD CONSTRAINT ORDER_FK1 FOREIGN KEY (client_id)
	  REFERENCES  CLIENT(id) ENABLE
ALTER TABLE ORDER ADD CONSTRAINT ORDER_FK2 FOREIGN KEY (address_id)
	  REFERENCES  ADDRESS(id) ENABLE

create table PRODUCT (
id number,
name varchar2( 50 ),
price number
);

create table ORDER_PRODUCT_LINK (
order_id number,
product_id number
);

ALTER TABLE ORDER_PRODUCT_LINKADD CONSTRAINT ORD_PR_LNK_FK1 FOREIGN KEY (order_id)
	  REFERENCES  ORDER(id) ENABLE
ALTER TABLE ORDER_PRODUCT_LINKADD CONSTRAINT ORD_PR_LNK_FK2 FOREIGN KEY (product_id)
	  REFERENCES  PRODUCT(id) ENABLE

create table ORDER_PRODUCT_LINK (
order_id number,
product_id number
);

ALTER TABLE ORDER_PRODUCT_LINK ADD CONSTRAINT ORD_PR_LNK_FK1 FOREIGN KEY (order_id)
	  REFERENCES  ORDER(id) ENABLE
ALTER TABLE ORDER_PRODUCT_LINK ADD CONSTRAINT ORD_PR_LNK_FK2 FOREIGN KEY (product_id)
	  REFERENCES  PRODUCT(id) ENABLE

create table ORDER (
ID number PRIMARY KEY,
name varchar2( 50 ),
cnt number,
client_id number not null,
address_id number
);


--Статистика заказов по адресу:
select o.name, 
       o.address_id, 
       count( 1 ) summ
from order o
group by o.address_id, o.name;