This tutorial shows how to install SQLite Studio and demonstrates how to create a database and write queries.  See the attachments tab for a link to download the database created in the video, 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.  This tutorial is shown in Windows but the process for a Mac is similar.

The database created in this tutorial is described in this Google doc that describes the customer order database: https://docs.google.com/document/d/1p4kTvpw2jc-bREy6nsJ1PX_VSLwm7gs-wewfks6dlPs/edit?usp=sharing

The home page for SQLite Studio is: https://sqlitestudio.pl/.  There is a link on that page to the GitHub site, which has all of the releases available for download: https://github.com/pawelsalawa/sqlitestudio/releases