Basic SQL and String Reverse | Dataford Interview Questions

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.

Requirements

Return each row's identifier, original text, reversed text, expected reversed text, and a Boolean validation result.
Treat two NULL values as a valid match, preserve empty strings, and order the output by string_id.

Schema

string_tests

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

Your question is Basic SQL and String Reverse. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Requirements

Return each row's identifier, original text, reversed text, expected reversed text, and a Boolean validation result.
Treat two NULL values as a valid match, preserve empty strings, and order the output by string_id.

Schema

string_tests

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

Your question is Basic SQL and String Reverse. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.