#305 Active Clients with a High Balance in Open Accounts

Companies:

Sberbank VTB

Themes:

SQLJoinsAggregationPractice

Find active clients whose open accounts have a total balance greater than 10000:

CREATE TABLE  clients
(
    client_id int primary key,
    name      varchar(100),
    manager   varchar(255)
);

CREATE TABLE accounts
(
    account_id     int primary key,
    client_id      int,
    account_number varchar(255),
    balance        decimal(10, 2),
    status         varchar(10),
    foreign key (client_id) references clients (client_id)
);

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.