From where? t_scenicspot_monthly？
Try to delete single quotation marks. Years and months can be regarded as plastic data.
Where is it? concat(year，LPAD(month，2，0))& gt； =20 1607? And then what? Concat (year, LPAD (month, 2, 0)) < =20 1707
Group? By who? I don't know what language your valuable project is. The following is a query statement spliced with C#
String? Inquiry? =? String. Format ("Select? Concat (year, LPAD (month, 2, 0))? As? ym？ , year? , month? , sum (take)? As? What? From where? t_scenicspot_monthly？ Where is it? concat(year，LPAD(month，2，0)>='{0}? And then what? Concat (year, LPAD (month, 2, 0)) < ='{ 1}'? Group? By who? Year, month? ","20 1607","20 1707")