schema.sql

-- =============================================================
-- Section 4 — Mathematical Operators and Functions
-- =============================================================
-- Reuses the cars dataset shape (same as section 11) so you can
-- focus on applying arithmetic and math functions, not learning a
-- new domain. Own schema means nothing collides with section 11.
-- =============================================================

DROP SCHEMA IF EXISTS sqlf_math CASCADE;
CREATE SCHEMA sqlf_math;
SET search_path TO sqlf_math;

CREATE TABLE cars (
    id          INTEGER,
    brand       VARCHAR(50)    NOT NULL,
    model       VARCHAR(50)    NOT NULL,
    price       NUMERIC(10, 2) NOT NULL,
    mileage     INTEGER        NOT NULL,
    is_electric BOOLEAN        NOT NULL
);