Script started on 2019-10-15 15:06:51-0400
pi:~/public_html> sqlite3 w3.sqlite

SQLite version 3.22.0 2018-01-22 18:45:57
Enter ".help" for usage hints.
sqlite> SELECT * FROM Persons WHERE City='Sandnes';
1           Hansen      Ola         Timoteivn 10  Sandnes   
2           Svendson    Tove        Borgvn 23     Sandnes   
sqlite> select LastName from Persons where Address like 'St%';
Pettersen 
sqlite> .quit
pi:~/public_html> exit

exit

Script done on 2019-10-15 15:08:46-0400