Filtering Dance Contest Scores
Given a table playground.dance_scores (columns: arbiter_id, first_criterion, second_criterion, third_criterion) with scores from 1 to 10 awarded by judges in a dance contest, write a query to exclude scores from any judge who awarded an extreme score (either minimum or maximum) for at least two criteria. Return the filtered scores, sorted by arbiter_id.
These are the tables to query for this question:
playground.dance_scores- arbiter_id int
- first_criterion int
- second_criterion int
- third_criterion int
Your answer should include these columns:
- arbiter_id integer
- first_criterion integer
- second_criterion integer
- third_criterion integer
Querying is only for logged in users!
Write Your Query Here (you can run selections by highlighting!)
Query Results
No queries have been run yet.