Your question is Basic SQL and String Reverse. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Costar property search data includes short text values that require validation during ingestion and transformation testing. Write a PostgreSQL query that reverses each value in the string_tests table and verifies the result against the stored expected value.
NULL values as a valid match, preserve empty strings, and order the output by string_id.| Column | Type | Description |
|---|---|---|
| string_idPK | INT | Unique test row identifier |
| input_text | VARCHAR(100) | Text value to reverse |
| expected_reverse | VARCHAR(100) | Expected reversed text used for validation |