Have followed the video in SQLite setup and got everything setup and was able to run queries in PowerShell, did go to control panel, added the path so it would be easier to access it later.
Problem - closed PowerShell and now cannot get to the database file anymore, tried the thing below.
How to open it again then?
sqlite> .open acs-1-year-2015.sqlite
sqlite> SELECT * FROM states;
Error: no such table: states