task Validation & types · hard

Parse money into exact integer cents

For every import row, parse raw_amount into cents or NULL and label status valid or invalid. Trim outer ASCII spaces. Accept an optional leading + or -, one to six ASCII whole-number digits, and optionally a decimal point followed by one or two ASCII digits.

what to return

Columns

import_idcentsstatus in this order

Rows

19 rows · in the order asked

Watch for

Leading zeros count toward the six-digit limit. Signed zero is valid. Missing whole digits, a trailing dot, exponents, separators, currency symbols and NULL are invalid.

Use integer cents: 19.99 is 1999 and -0.29 is -29. No floating-point tolerance is intended. Return every row ordered by import_id.

Skill

Turn validated decimal text into exact integer minor units. Refresher: CAST, text types & NULL arithmetic →

expected result

Your query should return exactly these columns and values. Run it and compare.

data you can query

Sample rows from each table. Each column shows its type underneath; → marks a link to another table.