按日期范围排序查询，然后按其他条件排序。联盟？ CONCATENATE？寻找想法

In my Android SQLite database, I have a column that is a datetime in the format YYYY-MM-DD HH:MM. I want a query (or a cursor, actually) that will give me all of the rows in, let's say May 2015. The sorting is where I'm getting stuck. I want my results broken down first by week, then for each week a sort based on other columns. In my Android SQLite database, I have a column