Question

TP框架下求以下问题的sql语句，如果有能执行该功能的代码最好

表A中有以下需要的字段：goods_id, nums, shop_id, add_time(时间戳)

将7天之内(add_time字段)同一shop_id且同一goods_id的nums求和并取其每个shop_id中的sum(nums)最大值的前5名

Answer 1

function singplay() {
var self = this;
this.prefix = "sing_play__fm_";
this.playIndex = -1;
this.listIndex = { PlayList: 0, MusicBox: 1 };
this.isLogin = false;
this.countMusicbox = -1;
this.cookieList = { PlayList: this.prefix + "0", MusicBox: this.prefix + "1" };
this.cookie;
this.agent;
this.init();