IF function in MySQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to use the IF function to check if the score is greater than 50.

MySQL

SELECT IF(score [1] 50, 'Pass', 'Fail') AS result FROM exams;

Drag options to blanks, or click blank then click option'

A<

B>

C=

D!=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '=' instead of '>' causes the condition to check equality, not greater than.

Using '<' reverses the logic and gives wrong results.

The IF function checks if the score is greater than 50. If true, it returns 'Pass', otherwise 'Fail'.

2fill in blank

medium

Complete the code to return 'Adult' if age is 18 or more, else 'Minor'.

MySQL

SELECT IF(age [1] 18, 'Adult', 'Minor') AS status FROM people;

Drag options to blanks, or click blank then click option'

A=

B<

C<=

D>=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '>' excludes exactly 18 years old.

Using '<=' reverses the logic.

The IF function checks if age is 18 or more using '>='. If true, it returns 'Adult', else 'Minor'.

3fill in blank

hard

Fix the error in the IF function to correctly check if salary is not equal to 0.

MySQL

SELECT IF(salary [1] 0, 'Has Salary', 'No Salary') FROM employees;

Drag options to blanks, or click blank then click option'

A=

B>

C!=

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '=' checks for equality, which is the opposite of what is needed.

Using '>' or '<' changes the logic incorrectly.

The '!=' operator checks if salary is not equal to 0. This fixes the error in the condition.

4fill in blank

hard

Fill both blanks to return 'High' if price is greater than 100, else 'Low'.

MySQL

SELECT IF(price [1] 100, '[2]', 'Low') AS price_level FROM products;

Drag options to blanks, or click blank then click option'

A>

B<

CHigh

DMedium

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' reverses the condition.

Returning 'Medium' instead of 'High' changes the expected output.

The IF function checks if price is greater than 100 using '>'. If true, it returns 'High', else 'Low'.

5fill in blank

hard

Fill both blanks to return the uppercase name if active is 1 and age is over 30, else return 'Inactive'.

MySQL

SELECT IF(active = 1 AND age [1] 30, UPPER(name), '[2]') AS status_name FROM users;

Drag options to blanks, or click blank then click option'

A>

B)

CInactive

D(

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting parentheses in UPPER function causes syntax errors.

Using '<' instead of '>' reverses the condition.

Returning wrong string instead of 'Inactive'.

The IF function checks if active is 1 and age is greater than 30 using '>'. The UPPER function needs an opening parenthesis '(' before the column name and a closing parenthesis ')' after it. If the condition is false, it returns 'Inactive'.