Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- wecoach_prod=# SELECT * FROM exercise;
- id | name | description | difficulty | category
- ----+--------+--------------+------------+----------
- 1 | PUSHUP | Push-Up | BEGINNER | STRENGTH
- 2 | PULLUP | Pull-Up | BEGINNER | STRENGTH
- 3 | SQUAT | Squat | BEGINNER | STRENGTH
- 4 | SITUP | Sit-Up | BEGINNER | STRENGTH
- 5 | SPRINT | Sprint (50m) | BEGINNER | STRENGTH
- (5 rows)
- wecoach_prod=# SELECT * FROM fitnessscore WHERE exercise_id = 2;
- id | student_id | exercise_id | score | video_path | test_date
- -----+------------+-------------+-------+------------+------------
- 73 | 9 | 2 | 0 | | 2024-04-09
- 78 | 10 | 2 | 0 | | 2024-04-09
- 82 | 15 | 2 | 0 | | 2024-04-09
- 88 | 12 | 2 | 0 | | 2024-04-09
- 95 | 16 | 2 | 0 | | 2024-04-09
- 99 | 18 | 2 | 0 | | 2024-04-09
- 107 | 19 | 2 | 0 | | 2024-04-09
- 119 | 11 | 2 | 0 | | 2024-04-09
- 127 | 21 | 2 | 0 | | 2024-04-09
- 142 | 8 | 2 | 0 | | 2024-04-09
- 143 | 14 | 2 | 0 | | 2024-04-09
- 144 | 20 | 2 | 0 | | 2024-04-09
- 145 | 23 | 2 | 0 | | 2024-04-09
- 146 | 26 | 2 | 0 | | 2024-04-09
- 147 | 25 | 2 | 0 | | 2024-04-09
- 148 | 24 | 2 | 0 | | 2024-04-09
- 149 | 28 | 2 | 0 | | 2024-04-09
- 150 | 29 | 2 | 0 | | 2024-04-09
- 151 | 27 | 2 | 0 | | 2024-04-09
- 152 | 22 | 2 | 0 | | 2024-04-09
Advertisement
Comments
-
- SELECT fitnessscore.id, fitnessscore.student_id, fitnessscore.exercise_id, fitnessscore.score, fitnessscore.video_path FROM student INNER JOIN fitnessscore ON student.id = fitnessscore.student_id WHERE fitnessscore.exercise_id >= 1 AND fitnessscore.exercise_id <=2 ORDER BY fitnessscore.student_id ASC;
Add Comment
Please, Sign In to add comment
Advertisement