tasks_by_objective

11 rows where objective = 1

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ task objective
1 Eat as much watermelon as possible 2 grams ▲ 1
57 Get the flour onto the target 102 grams ▲ 1
118 Identify the baby food flavours 221 grams ▲ 1
165 Collect the most doughnuts in your bucket 327 grams ▲ 1
216 Put the most spaghetti in a grapefruit 444 grams ▲ 1
221 Bag the heaviest thing from the greatest distance 453 grams ▲ 1
224 Feed your team-mate(s) the most watermelon 456 grams ▲ 1
260 Make your rubber gloves and wellies as heavy as possible 526 grams ▲ 1
324 Eat your beautiful sculpture 635 grams ▲ 1
336 Don't pop the balloon 662 grams ▲ 1
339 Put five grapes in the little bowl 666 grams ▲ 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE tasks_by_objective (
   id        INTEGER PRIMARY KEY,
   task      INTEGER REFERENCES tasks(id),
   objective INTEGER REFERENCES objectives(id)
);