mysql两个sql相减函数_Mysql sql 实现两行数据相减的sql写法

须具备的数据库脚本：

CREATE TABLE `NewTable` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '流水ID数据库自增字段' ,

`queue_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '队列名称' ,

`tenant_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '租户ID' ,

`user_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户ID' ,

`product_total_count` bigint(20) NOT NULL COMMENT '生产消息总数' ,

`consume_total_count` bigint(20) NOT NULL COMMENT '消费消息总数' ,

`consumer_count` bigint(20) NOT NULL COMMENT '消费者数量' ,

`statistic_time` datetime NOT NULL COMMENT '统计时间' ,

`create_time` datetime NOT NULL COMMENT '记录创建时间' ,

PRIMARY KEY (`id`)

)<