2,209
社区成员
发帖
与我相关
我的任务
分享
sqlite> select * from table1;
zhangsan|语文|90|20080101
zhangsan|语文|56|20080701
zhangsan|语文|59|20070901
zhangsan|数学|90|20080101
zhangsan|数学|70|20080901
zhangsan|数学|88|20090101
lisi |数学|90|20090101
sqlite> select student,
...> sum((subject='数学')*score)/sum((subject='数学')) as avg数学,
...> sum((subject='语文')*score)/sum((subject='语文')) as avg语文
...> from table1
...> where date>'2007010'
...> group by student;
lisi |90|
zhangsan|82|68
sqlite>