SQL coding challenge
Ordering results
āØ Your Task
Select all rows from the movie table sorted by year in a descending order.
| 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
| id | name | year | director |
|---|---|---|---|
| 4 | The Avengers | 2012 | Joss Whedon |
| 3 | Titanic | 1997 | James Cameron |
| 2 | The Terminator | 1984 | James Cameron |
| 1 | The Godfather | 1972 | Francis Ford Coppola |
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