Supernatural accuracy

Tags
Challenge
No

Coach Doc

Supernatural is Cthulhu's fave workout app, for the Oculus Quest. That's Coach Doc, lunging to hit some virtual targets.

Some of Cthulhu's goaty friends use the app, too. Each workout is scored on accuracy and power, numbers from 0 to 100.

The latest workout scores have been put into a database called supernatural. There's one table, called workout. Here's some of its data:

Data

Download a zip that you can import into a database, to recreate the tables and data. So, make the database in phpMyAdmin, then use the import tab to import the file you downloaded.

Write a program to help Cthulhu see how many goats meet a minimum accuracy standard. The minimum comes through the URL, like this:

  • something.php?min=90

Attachments
Where referenced