SQL coding challenge
Matching strings using LIKE operator
āØ Your Task
Select the names of all movies from the movie table that start with The.
| id | name | year | director |
|---|---|---|---|
| 1 | The Godfather | 1972 | Francis Ford Coppola |
| 2 | The Terminator | 1984 | James Cameron |
| 3 | Titanic | 1997 | James Cameron |
| 4 | The Avengers | 2012 | Joss Whedon |
āļø SQL SQLite dialect
š Press "Run" and check the result below.
Script output
Script not executed yet
Expected script output
| name |
|---|
| The Godfather |
| The Terminator |
| The Avengers |
Want to try another challenge?
- JavaScript
- Python
- PHP
- SQL
SQL Fundamentals
A set of coding problems that cover the basic syntax and features of the programming language.
1. Retrieving data
2. Manipulating data