# 需求分析注:如果当天出现多个用户同时最早登录,那么这些用户均需要输出 # 输出日期、用户id、用户内容喜好,结果按照日期升序排序 SELECT DATE_FORMAT( a.log_time,'%Y-%m-%d') as log_day, a.user_id, c.hobby FROM ( SELECT user_id,log_time from login_tb ) a INNER JOIN ( SELECT DATE_FORMAT( log_time,'%Y-%m-%d') as log_time,min(log_time) a...