Statistics on the activity of OSC employees on the website (Assessment)

This SQL statement is used to count the active days of all OSC employees on the OSChina website every month. OSCHINASELECTu. NAME, extract (YEAR_MONTHFROMcreate_time) ym, COUNT (DISTINCTDAY (create_time) 'Count' FROMosc _ opt_logso, osc_usersuWHEREo.USERu.idA

This SQL statement is used to count the active days of all OSC employees on the OSChina website every month. Oschina select u. NAME, extract (YEAR_MONTH FROM create_time) ym, COUNT (distinct day (create_time) 'Count' FROM osc_opt_logs o, osc_users u WHERE o. USER = u. id

This SQL statement is used to count the active days of all OSC employees on the OSChina website every month. OSCHINA

SELECT u.NAME, extract(YEAR_MONTH FROM create_time) ym, COUNT(DISTINCT DAY(create_time)) `count` FROM osc_opt_logs o, osc_users u WHERE o. USER = u.id AND u.id IN ( xxx , xxx, xxx, xxx, xxx) AND ( DATE_SUB(CURDATE(), INTERVAL 1 MONTH) <= o.create_time ) GROUP BY USER, ym ORDER BY ym DESC, `count` desc;