I know, it's too late to reply but it will help anyone looking for detailed info on sqlite select statement. The following sqlite topics will help better to understand select statement in sqlite.

SQLite Select Statement

To learn more about sqlite, refer the following

SQLite Tutorial

If you want to start learn programming from basics check following tutorials.

https://www.tutlane.com/tutorial/android
https://www.tutlane.com/tutorial/csharp
https://www.tutlane.com/tutorial/sqlite
https://www.tutlane.com/tutorial/swift
https://www.tutlane.com/tutorial/ios
https://www.tutlane.com/tutorial/angularjs
https://www.tutlane.com/tutorial/sql-server
https://www.tutlane.com/tutorial/linq
https://www.tutlane.com/tutorial/jquery
https://www.tutlane.com/tutorial/javascript
https://www.tutlane.com/tutorial/nodejs

and many more tutorials at following section

https://www.tutlane.com/tutorials

check following articles to create a simple android native app.

https://www.tutlane.com/tutorial/android/android-imageswitcher-with-examples
https://www.tutlane.com/tutorial/android/android-hello-world-app-example
https://www.tutlane.com/tutorial/android/android-tabs-with-fragments-and-viewpager


To learn complete android with examples, check following url.

https://www.tutlane.com/tutorial/android

Good one. You can follow Tutlane.com tutorials to learn more about javascript frameworks in detail with examples.

https://www.tutlane.com/tutorial/angularjs
https://www.tutlane.com/tutorial/javascript
https://www.tutlane.com/tutorial/jquery

and many more tutorials at following url

https://www.tutlane.com/tutorials

Even i found another site (tutlane.com) which offering free tutorials on c#, Mvc, Jquery And More Tutorials Online for free.

Check following urls to learn c#, mvc, sql, sqlite, android, ios, etc. with examples from basic to advanced

https://www.tutlane.com/tutorial/csharp
https://www.tutlane.com/tutorial/aspnet-mvc
https://www.tutlane.com/tutorial/angularjs
https://www.tutlane.com/tutorial/jquery
https://www.tutlane.com/tutorial/sql-server
https://www.tutlane.com/tutorial/sqlite

To learn software programming languages for free from basic to advanced check https://www.tutlane.com site they provided good set of tutorials from basic to advanced level for completely free.

Check some of following tutorials they covered to learn android, c#, .net, mvc, sql, ios, swift, etc.

https://www.tutlane.com/tutorial/angularjs
https://www.tutlane.com/tutorial/android
https://www.tutlane.com/tutorial/ios
https://www.tutlane.com/tutorial/swift
https://www.tutlane.com/tutorial/aspnet-mvc