#77 Total Payments per Person

Companies:

Innotech

Themes:

SQLJoinsAggregationPractice

Find the names of all people and the total of their payments, if any:

CREATE TABLE Persons (
    id bigint primary key,
    name text
);

CREATE TABLE Payment (
    id bigint primary key,
    person_id bigint,
    value decimal
);

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.