$ sqlite3 -header -column animal.sqlite 
SQLite version 3.11.0 2016-02-15 17:29:24
Enter ".help" for usage hints.
sqlite> select * from summary;
type        count(*)  
----------  ----------
cat         3         
dog         1         
lion        2         
tiger       2         
sqlite> select * from cats_only;
id          name      
----------  ----------
1           Felix     
2           Sylvester 
3           Garfield  
sqlite> .q