1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| package com.example.firstapp.model
|
| import androidx.room.ColumnInfo
| import androidx.room.DatabaseView
|
| @DatabaseView(
| """
| SELECT substr(createTime, 1, 10) as date,
| COUNT(*) as count
| FROM code
| GROUP BY substr(createTime, 1, 10)
| """
| )
| data class DailyStat2(
| val date: String,
| val count: Int
| )
|
|
