example-sql-question.json

{
  "type": "PLAYGROUND",
  "text": "`PLAYGROUND`: Run a query to generate the titles of each movie.",
  "setup_sql": "CREATE TABLE movies    (Id INTEGER, Title TEXT(19), Director TEXT(14), Year INTEGER, Length_minutes INTEGER);;INSERT INTO movies    (Id, Title, Director, Year, Length_minutes)VALUES    (1, 'Toy Story', 'John Lasseter', 1995, 81);INSERT INTO movies    (Id, Title, Director, Year, Length_minutes)VALUES    (2, 'A Bug''s Life', 'John Lasseter', 1998, 95);INSERT INTO movies    (Id, Title, Director, Year, Length_minutes)VALUES    (3, 'Toy Story 2', 'John Lasseter', 1999, 93);INSERT INTO movies    (Id, Title, Director, Year, Length_minutes)VALUES    (4, 'Monsters, Inc.', 'Pete Docter', 2001, 92);INSERT INTO movies    (Id, Title, Director, Year, Length_minutes)VALUES    (5, 'Finding Nemo', 'Andrew Stanton', 2003, 107);INSERT INTO movies    (Id, Title, Director, Year, Length_minutes)VALUES    (6, 'The Incredibles', 'Brad Bird', 2004, 116);INSERT INTO movies    (Id, Title, Director, Year, Length_minutes)VALUES    (7, 'Cars', 'John Lasseter', 2006, 117);INSERT INTO movies    (Id, Title, Director, Year, Length_minutes)VALUES    (8, 'Ratatouille', 'Brad Bird', 2007, 115);INSERT INTO movies    (Id, Title, Director, Year, Length_minutes)VALUES    (9, 'WALL-E', 'Andrew Stanton', 2008, 104);INSERT INTO movies    (Id, Title, Director, Year, Length_minutes)VALUES    (10, 'Up', 'Pete Docter', 2009, 101);INSERT INTO movies    (Id, Title, Director, Year, Length_minutes)VALUES    (11, 'Toy Story 3', 'Lee Unkrich', 2010, 103);INSERT INTO movies    (Id, Title, Director, Year, Length_minutes)VALUES    (12, 'Cars 2', 'John Lasseter', 2011, 120);INSERT INTO movies    (Id, Title, Director, Year, Length_minutes)VALUES    (13, 'Brave', 'Brenda Chapman', 2012, 102);INSERT INTO movies    (Id, Title, Director, Year, Length_minutes)VALUES    (14, 'Monsters University', 'Dan Scanlon', 2013, 110);",
  "hints": [
    "Use the `SELECT` keyword to select column(s) FROM a table.",
    "The `SELECT` syntax was:\r\n```sql\r\nSELECT column_name FROM table_name;\r\n```"
  ],
  "slug": "playground-question",
  "playground_data": {
    "initialQuery": "SELECT ? FROM movies",
    "answerDQL": "SELECT title FROM movies;"
  }
}