56,679
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE `kgl_jfkxfdz` (
`ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`JYRQ` date DEFAULT NULL COMMENT '交易日期',
`JYSJ` time DEFAULT NULL COMMENT '交易时间',
`SHMC` varchar(32) DEFAULT NULL COMMENT '商户名称',
`KH` varchar(20) DEFAULT NULL COMMENT '卡号',
`JYLX` varchar(8) DEFAULT NULL COMMENT '交易类型',
`JYJE` decimal(12,2) DEFAULT NULL COMMENT '交易金额',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=192 DEFAULT CHARSET=utf8;
INSERT INTO `kgl_jfkxfdz` VALUES ('1', '2010-01-01', '06:36:18', '144440199000001','87601144000001100','消费','0.01');
INSERT INTO `kgl_jfkxfdz` VALUES ('2', '2010-02-22', '06:41:36', '144440199000001','87601144000001100','撤销','-0.01');
INSERT INTO `kgl_jfkxfdz` VALUES ('3', '2010-03-22', '06:48:34', '144440199000001','87601144000001100','消费','0.02');
INSERT INTO `kgl_jfkxfdz` VALUES ('4', '2010-04-22', '06:57:28', '144440199000001','87601144000001100','撤销','-0.01');
INSERT INTO `kgl_jfkxfdz` VALUES ('5', '2010-05-22', '07:02:20', '144440199000001','87601144000001100','消费','0.03');
INSERT INTO `kgl_jfkxfdz` VALUES ('5', '2010-06-22', '07:02:20', '144440199000001','87601144000001100','消费','0.04');
INSERT INTO `kgl_jfkxfdz` VALUES ('5', '2010-07-22', '07:02:20', '144440199000001','87601144000001100','消费','0.05');
INSERT INTO `kgl_jfkxfdz` VALUES ('5', '2010-08-22', '07:02:20', '144440199000001','87601144000001100','消费','0.06');
INSERT INTO `kgl_jfkxfdz` VALUES ('5', '2010-09-22', '07:02:20', '144440199000001','87601144000001100','消费','0.07');
INSERT INTO `kgl_jfkxfdz` VALUES ('5', '2010-10-22', '07:02:20', '144440199000001','87601144000001100','消费','0.08');
INSERT INTO `kgl_jfkxfdz` VALUES ('5', '2010-11-22', '07:02:20', '144440199000001','87601144000001100','消费','0.08');
INSERT INTO `kgl_jfkxfdz` VALUES ('5', '2010-12-22', '07:02:20', '144440199000001','87601144000001100','消费','0.10');
第一问期望结果:
交易总额 交易日期
xx.xx xx年 总第xx周 当月xx周
xx.xx xx年 总第xx周 当月xx周
第二问期望结果:
交易总额 交易日期
xx.xx xx年 xx月
xx.xx xx年 xx月
第三问期望结果:
交易总额 交易日期
xx.xx 第xx季度
xx.xx 第xx季度