貝森朵芙巡更
跳至導覽
跳至搜尋
<SQL> SELECT DATE_FORMAT(DT,'%Y/%m/%d')DAY,PLACE,O,COUNT(PLACE) TIME FROM GOGO JOIN building ON PLACE=B WHERE DATE_FORMAT(DT,'%Y/%m')='2018/05' GROUP BY DATE_FORMAT(DT,'%Y/%m/%d'),PLACE,O </SQL>
2版
<SQL> SELECT DATE_FORMAT(DT,'%Y/%m/%d')DAY,B,O,COUNT(PLACE) TIME FROM GOGO JOIN building ON PLACE=A WHERE DATE_FORMAT(DT,'%Y/%m')='2018/09' GROUP BY DATE_FORMAT(DT,'%Y/%m/%d'),O </SQL>