This tutorial shows how to write SQL queries in SQLite Studio.  This tutorial shows how tables can be created using SQL commands and how data can be inserted using SQL commands. 

See the attachments tab for a link to download the database created in the video, including the "temp.db" database that was created, the SQL code saved in an SQL file that can be opened in SQLite Studio and the libsqlitefunctions extension file that enables additional functions not available by default.

Written Tutorial:

Here is an expanded tutorial in a Google doc showing the SQL statements that can be used to create the database (much of the code is in the attached sql code): https://docs.google.com/document/d/1tYlg7pyDep95hsBSDK-CY1kbNoMTvxprB8w3FOqW5HM