Script started on 2019-10-15 15:10:59-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 ORDER BY LastName;
1|Hansen|Ola|Timoteivn 10|Sandnes
3|Pettersen|Kari|Storgt 20|Stavanger
2|Svendson|Tove|Borgvn 23|Sandnes
sqlite> 
sqlite> SELECT * FROM Persons ORDER BY LastName DESC;
2|Svendson|Tove|Borgvn 23|Sandnes
3|Pettersen|Kari|Storgt 20|Stavanger
1|Hansen|Ola|Timoteivn 10|Sandnes
sqlite> SELECT FirstName,LastName FROM Persons ORDER BY LastName DESC;
Tove|Svendson
Kari|Pettersen
Ola|Hansen
sqlite> .quit
pi:~/public_html> exit

exit

Script done on 2019-10-15 15:12:41-0400