Prompt Bill Update
Write MySQL 5.7 code to update status column in `bill` table with information from `receipt` table.
If the bill is fully paid, then the status should be updated to 'PAID'.
If the bill is partially paid, then the status should be updated to 'PARTIAL'.
If the bill is not paid at all, then the status should be updated to 'UNPAID'.when to use it
Community prompt sourced from the open-source GitHub repo paradite/eval-data (no explicit license). A "Prompt Bill Update" style prompt — adapt the placeholders and specifics to your task. Imported as-is and not independently retested here, so check the output before relying on it.
tags
roleplaycommunitygeneral
source
paradite/eval-data · no explicit license