### Database Schema:
CREATE TABLE client (
	client_id	INTEGER	NOT NULL	PRIMARY KEY,
	gender	TEXT	NOT NULL,
	birth_date	DATE	NOT NULL,
	district_id	INTEGER	NOT NULL,
	foreign key (district_id) references district (district_id)
);

CREATE TABLE account (
	account_id	INTEGER	NOT NULL	DEFAULT 0	PRIMARY KEY,
	district_id	INTEGER	NOT NULL	DEFAULT 0,
	frequency	TEXT	NOT NULL,
	date	DATE	NOT NULL,
	foreign key (district_id) references district (district_id)
);

CREATE TABLE order (
	order_id	INTEGER	NOT NULL	DEFAULT 0	PRIMARY KEY,
	account_id	INTEGER	NOT NULL,
	bank_to	TEXT	NOT NULL,
	account_to	INTEGER	NOT NULL,
	amount	REAL	NOT NULL,
	k_symbol	TEXT	NOT NULL,
	foreign key (account_id) references account (account_id)
);

CREATE TABLE trans (
	trans_id	INTEGER	NOT NULL	DEFAULT 0	PRIMARY KEY,
	account_id	INTEGER	NOT NULL	DEFAULT 0,
	date	DATE	NOT NULL,
	type	TEXT	NOT NULL,
	operation	TEXT	NULL,
	amount	INTEGER	NOT NULL,
	balance	INTEGER	NOT NULL,
	k_symbol	TEXT	NULL,
	bank	TEXT	NULL,
	account	INTEGER	NULL,
	foreign key (account_id) references account (account_id)
);

CREATE TABLE district (
	district_id	INTEGER	NOT NULL	DEFAULT 0	PRIMARY KEY,
	A2	TEXT	NOT NULL,
	A3	TEXT	NOT NULL,
	A4	TEXT	NOT NULL,
	A5	TEXT	NOT NULL,
	A6	TEXT	NOT NULL,
	A7	TEXT	NOT NULL,
	A8	INTEGER	NOT NULL,
	A9	INTEGER	NOT NULL,
	A10	REAL	NOT NULL,
	A11	INTEGER	NOT NULL,
	A12	REAL	NULL,
	A13	REAL	NOT NULL,
	A14	INTEGER	NOT NULL,
	A15	INTEGER	NULL,
	A16	INTEGER	NOT NULL
);

CREATE TABLE loan (
	loan_id	INTEGER	NOT NULL	DEFAULT 0	PRIMARY KEY,
	account_id	INTEGER	NOT NULL,
	date	DATE	NOT NULL,
	amount	INTEGER	NOT NULL,
	duration	INTEGER	NOT NULL,
	payments	REAL	NOT NULL,
	status	TEXT	NOT NULL,
	foreign key (account_id) references account (account_id)
);

CREATE TABLE disp (
	disp_id	INTEGER	NOT NULL	PRIMARY KEY,
	client_id	INTEGER	NOT NULL,
	account_id	INTEGER	NOT NULL,
	type	TEXT	NOT NULL,
	foreign key (client_id) references client (client_id),
	foreign key (account_id) references account (account_id)
);

CREATE TABLE card (
	card_id	INTEGER	NOT NULL	DEFAULT 0	PRIMARY KEY,
	disp_id	INTEGER	NOT NULL,
	type	TEXT	NOT NULL,
	issued	DATE	NOT NULL,
	foreign key (disp_id) references disp (disp_id)
);

### User's Query:
Which districts have transactions greater than USS$10,000 in 1997?

### Extra Knowledge:

SELECT T1.district_id FROM account AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id INNER JOIN trans AS T3 ON T1.account_id = T3.account_id WHERE STRFTIME('%Y', T3.date) = '1997' GROUP BY T1.district_id HAVING SUM(T3.amount) > 10000