Number 1 Hits - SQL view

Search and sort the database by typing in an SQL SELECT statement below.

  • The table is called hits.
  • The fields in it are id, date, artist, title, weeks, label, tally and trivia.
  • Use single quotes (') around text values.
  • Don't forget to finish your statement with a semicolon.

Alternatively, go to standard view.