One of the values in the MySQL database is in the first row of the item, and it's a few hundred minutes.

SQL is as follows:

SQL 1.

SELECTX.user_id, X.total_no, X.order_no, X.order_no/X.total_no asPercentage_no from(SELECT @rowNum:= @rowNum + 1  asOrder_no,@rowCount  asTotal_no,user_id     fromT_sd_user, (SELECT @rowNum:= 0) b, (SELECT @rowCount:= (                SELECT COUNT(*)                 fromT_sd_user)) CORDER  by user_id DESC) XWHERE user_id = 3008

Sql2.

SELECTx.comment_id, X.total_no, Order_no, Ifnull (x.order_no/X.total_no,1) asPercentage_no from(SELECT @rowNum:= @rowNum + 1  asOrder_no,@rowCount  astotal_no, t.comment_id, t.comment_spending fromT_sd_comment T, (SELECT @rowNum:= 0) b, (SELECT @rowCount:= (                SELECT COUNT(*)                 fromt_sd_commentWHERETo_days (Create_time)>=To_days (now ()))) CORDER  byCreate_timeDESC) XWHEREcomment_id=  the