SELECT ToDoItem FROM BucketList; Showing rows 0 - 24 (3338 total, Query took 0.0046 seconds.)
DELETE FROM BucketList WHERE ToDoPriority = "low"; SELECT ToDoItem, WorkToBeDone FROM BucketList WHERE ToDoPriority = "high"; Showing rows 0 - 24 (1595 total, Query took 0.0046 seconds.)
DELETE FROM BucketList WHERE WorkToBeDone BETWEEN 7 and 10; SELECT MIN(WorkToBeDone) AS LeastWork FROM BucketList WHERE ToDoPriority = "high"; Check result.
Ok, this is an acceptable value.
SELECT ToDoItem FROM BucketList WHERE ToDoPriority = "high" GROUP BY ToDoLocation; Showing rows 0 - 7 (8 total, Query took 0.0189 seconds.)
Interesting places…
DELETE FROM BucketList WHERE ToDoLocation LIKE %Ratingen%; SELECT ToDoItem FROM BucketList WHERE ToDoPriority = "high" GROUP BY ToDoLocation ORDER BY RecreationFactor DESC;
Showing rows 0 – 5 (6 total, Query took 0.0189 seconds.)
Great, now we have a plan!