1create view v1 as select tag, count(*) from android_logs group by tag order by 2 desc limit 5 2 3create view v2 as select tag, count(*) from android_logs group by tag order by 2 asc limit 5; 4 5create view v3 as select tag, count(*) from android_logs where msg like '%wakelock%' group by tag; 6 7create view v4 as select msg, 1 from android_logs limit 10; 8 9select * from v1 union all 10select '-----', 0 union all 11select * from v2 union all 12select '-----', 0 union all 13select * from v3 union all 14select '-----', 0 union all 15select * from v4;