Scenario

You have a table of user-submitted text entries that may or may not represent valid mathematical expressions.

Task

Write a Snowflake SQL query that:

1. Selects all columns from {{ ref("expressions") }}
2. Filters to only include rows where the expression column is a valid math expression (contains only digits and the operators +, -, *, /, with at least one operator separating digit groups)

Schema

expressions

Example

expressions:

Expected Output:

Note: Only rows containing digits separated by arithmetic operators (+, -, *, /) are kept. Rows with alphabetic characters or other non-matching patterns are excluded.