From the course: MySQL Data Analysis

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Challenge: The CASE statement

Challenge: The CASE statement - MySQL Tutorial

From the course: MySQL Data Analysis

Start my 1-month free trial Buy for my team

Challenge: The CASE statement

“

- [Instructor] All right, let's test your skills with the assignment on Case Statements. For this assignment, your business partner, Uncle Jimmy, is trying to figure out which store each customer goes to, and he wants to know whether or not they're still active. He wants a list of first names and last names for all customers, and he wants them labeled as either store 1 active, store 1 inactive, store 2 active, or store 2 inactive. Your result grid should look like this with first name, last name, and then their status. Try and get through this yourself. Hopefully you get to the answer, or at least struggle through and try to learn it, and then come back and watch the Solution Video.

Contents