SQL Playground
Interactive Database Queries
Practice SQL with Multiple Databases
Select Database
IMDB Movies
Top 1000 movies from IMDB with ratings, cast, and box office data
Currently Selected
Criminal History
Hibbing MHC participant criminal history data with charges and outcomes
Rick & Morty Scripts
Dialogue and character data from Rick and Morty TV show episodes
IMDB Movies Schema
Table: movies(1,000 records)
Basic Information
id (INTEGER) - Unique movie identifier
title (TEXT) - Movie title e.g., “The Shawshank Redemption”
year (INTEGER) - Release year e.g., 1994
poster (TEXT) - Movie poster URL
overview (TEXT) - Plot summary
Ratings & Reviews
imdb_score (REAL) - IMDB rating e.g., 9.3
meta_score (INTEGER) - Metacritic score e.g., 80
votes (INTEGER) - Number of IMDB votes
rating_cert (TEXT) - Age rating e.g., “R”, “PG-13”
Cast & Crew
director (TEXT) - Movie director
star1 (TEXT) - Lead actor/actress
star2 (TEXT) - Second lead
star3 (TEXT) - Third lead
star4 (TEXT) - Fourth lead
Technical & Financial
runtime (INTEGER) - Duration in minutes
genre (TEXT) - Movie genre e.g., “Drama”
gross (INTEGER) - Box office earnings (USD)