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!

Please follow and like the content: