원포인트 PT 운영 쿼리

SELECT wday.daystr AS '운동일자', setrep.kindof as '운동 종류', exercise.name AS '운동명', setrep.weight as '무게', setrep.reps as '횟수', setrep.rpe FROM setrep INNER JOIN day_exercise ON setrep.de_id = day_exercise.id INNER JOIN exercise ON day_exercise.e_id = exercise.id INNER JOIN wday ON wday.id = day_exercise.d_id WHERE wday.status = 'done' AND setrep.state = 'success' AND wday.daystr >= (SELECT strftime('%Y-%m-%d', MAX(wday.daystr), '-3 months') FROM wday WHERE wday.status = 'done') AND wday.daystr <= (SELECT MAX(wday.daystr) FROM wday WHERE wday.status = 'done');

SELECT date as '측정 날짜' , weight as '체중', muscleMass as '근육량', bodyFatPercentage as '체지방률' FROM body_composition WHERE date >= (SELECT strftime('%Y-%m-%d', MAX(date), '-3 months') FROM body_composition);