If I were doing this exercise on Windows, I might well use the visual SQL query builder and SQL command line in Alpha Anywhere ... DROP TABLE DROP TABLE CREATE TABLE CREATE TABLE CREATE TABLE ...

Once you’ve installed SQLite, you’ll probably want to learn how to maneuver around the database’s command line interface (CLI). The SQLite CLI allows you to issue any valid SQL statements you like. To ...

Don't be afraid of using your chosen database's command ... single line, or they can be broken up across many lines to make it easier to read. In the examples below, I do the latter. SQL statements ...