Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
In the same movies table, some movie titles follow a pattern where the third character is a space, e.g., "Mr Smith", "Up Close", "Go Away".
Write a SQL query to find all movies ID and their corresponding title where the third character in the title is a space.
| movie_id | title |
|---|---|
| 12 | Jo Rabbit |
| 31 | La La Land |
| 11 | Mr Smith |
In the same movies table, some movie titles follow a pattern where the third character is a space, e.g., "Mr Smith", "Up Close", "Go Away".
Write a SQL query to find all movies ID and their corresponding title where the third character in the title is a space.
| movie_id | title |
|---|---|
| 12 | Jo Rabbit |
| 31 | La La Land |
| 11 | Mr Smith |