Prep Room
Sign inCreate account
Code Room
Code reviewMediumcr-g645
Subject Database money typeLevel Mid–Senior~20 minCommon in Databases & SQL interviewsIndustries Software development

Question

Review this schema and the Python that writes to it.

What a strong answer looks like

Separate real bugs from style. Rank issues by severity, point at the root cause rather than the symptom, and suggest a concrete fix — specific and kind.

Learn the concepts
Talk through your review
Code to reviewsql
CREATE TABLE invoices (    id        BIGSERIAL PRIMARY KEY,    customer  TEXT NOT NULL,    amount    DOUBLE PRECISION NOT NULL,   -- dollars    tax_rate  DOUBLE PRECISION NOT NULL);
Run or narrate your approach, then ask the coach.