HI i have these two tables shown below.
CREATE TABLE accounts
(
account INTEGER NOT NULL,
account_type ENUM('single','corporation')NOT NULL,
last_trans_date DATE NOT NULL,
minimum_balance DECIMAL(10,2) NOT NULL,
balance DECIMAL(10,2) NOT NULL,
PRIMARY KEY (account)
);
CREATE TABLE transactions...