如何在sqlite android中对行进行捆绑排序

// 获取SQLiteDatabase实例
SQLiteDatabase db = this.getReadableDatabase();

// 构建查询语句
String query = "SELECT * FROM users ORDER BY lastName ASC, firstName ASC, age DESC";

// 执行查询
Cursor cursor = db.rawQuery(query, null);

// 遍历结果集
if (cursor.moveToFirst()) {
    do {
        String firstName = cursor.getString(cursor.getColumnIndex("firstName"));
        String lastName = cursor.getString(cursor.getColumnIndex("lastName"));
        int age = cursor.getInt(cursor.getColumnIndex("age"));
        
        // 处理每一行数据
        Log.d("User", "Name: " + firstName + " " + lastName + ", Age: " + age);
    } while (cursor.moveToNext());
}

// 关闭Cursor和数据库连接
cursor.close();
db.close();

SELECT * FROM users ORDER BY lastName ASC, firstName ASC, age DESC, (age IS NULL) ASC;