Initializing SQL database...
Back to Questions
CASE Statement - Categorize #41
mediumCategorize values as High (>200), Medium (100-200), or Low (<100). Multiple WHEN conditions or CASE statements combined with other operations. The conditions are evaluated in order, so put more specific conditions first.
Practice with:
Database Schema
data
Data records
idnamevalue
Expected Output
Click "Show" to see what the correct output should look like.Tip: Try solving it yourself first for better learning!
SQL Editor
Loading...
Press Ctrl+Enter to run query • Start typing for autocomplete