러닝 SQL: 데이터 생성, 검색, 조작까지 데이터 제대로 주무르기

274

러닝 SQL

mysql> SELECT first_name, last_name,

-> CASE

-> WHEN active = 1 THEN 'ACTIVE'

-> ELSE 'INACTIVE'

-> END activity_type

-> FROM customer;

+-------------+--------------+---------------+

| first_name | last_name | activity_type |

+-------------+--------------+---------------+

| MARY | SMITH | ACTIVE |

| PATRICIA | JOHNSON | ACTIVE |

| LINDA | WILLIAMS | ACTIVE |

| BARBARA | JONES | ACTIVE |

| ELIZABETH | BROWN | ACTIVE |

| JENNIFER | DAVIS | ACTIVE |

...

| KENT | ARSENAULT | ACTIVE |

| TERRANCE | ROUSH | INACTIVE |

| RENE | MCALISTER | ACTIVE |

| EDUARDO | HIATT | ACTIVE |

| TERRENCE | GUNDERSON | ACTIVE |

| ENRIQUE | FORSYTHE | ACTIVE |

| FREDDIE | DUGGAN ...