Orders over 100 when amounts are text

staging_orders.amount_text holds order amounts as text — one row even says n/a. Return order_ref and amount (as a number) for orders whose amount is greater than 100. Rows whose amount isn't a number are skipped. Sort by order_ref.

Tables & sample data

staging_orders

10 rows total · first 5 shown

order_refvarchar	amount_textvarchar	qtybigint	order_date_textvarchar
so_01	90	1	2026-05-01
so_02	1000	2	2026-05-01
so_03	250	1	05/02/2026
so_04	n/a	1	05/02/2026
so_05	75.50	3	2026-05-02

query.sql

Loading editor…