CREATE TABLE clients (
    id_client INTEGER PRIMARY KEY,
    nom VARCHAR(50) NOT NULL,
    age INTEGER,
    ville VARCHAR(30)
);

CREATE TABLE comptes (
    id_compte INTEGER PRIMARY KEY,
    id_client INTEGER NOT NULL,
    type_compte VARCHAR(20),
    solde_usd DECIMAL(12,2),
    date_ouverture DATE,
    FOREIGN KEY (id_client) REFERENCES clients(id_client)
);

CREATE TABLE transactions (
    id_transaction INTEGER PRIMARY KEY,
    id_compte INTEGER NOT NULL,
    type_operation VARCHAR(20),
    montant_usd DECIMAL(12,2),
    date_operation DATE,
    FOREIGN KEY (id_compte) REFERENCES comptes(id_compte)
);

INSERT INTO clients (id_client, nom, age, ville) VALUES
(1, 'Jean Mukendi',   34, 'Kinshasa'),
(2, 'Marie Kabila',   28, 'Lubumbashi'),
(3, 'Patrick Ilunga', 45, 'Goma'),
(4, 'Sarah Mbuyi',    31, 'Kinshasa'),
(5, 'Alain Mwamba',   60, 'Lubumbashi');

INSERT INTO comptes (id_compte, id_client, type_compte, solde_usd, date_ouverture) VALUES
(101, 1, 'Courant', 2450.00,  '2019-03-12'),
(102, 2, 'Épargne', 5800.00,  '2021-07-01'),
(103, 3, 'Courant', 12300.00, '2015-11-20'),
(104, 4, 'Épargne', 3150.00,  '2020-02-14'),
(105, 5, 'Épargne', 41000.00, '2010-04-05');

INSERT INTO transactions (id_transaction, id_compte, type_operation, montant_usd, date_operation) VALUES
(1001, 101, 'Dépôt',    500.00,  '2026-11-02'),
(1002, 103, 'Retrait',  1200.00, '2026-11-05'),
(1003, 102, 'Dépôt',    800.00,  '2026-11-07'),
(1004, 105, 'Retrait',  2000.00, '2026-11-10'),
(1005, 101, 'Retrait',  150.00,  '2026-11-12');
Select*from clients as client ;