Skip to content

Locate people

1. Problem

해당 문제는 여기에서 확인하실 수 있습니다.

2. Answer

SELECT department_name, location
FROM departments
WHERE location LIKE 'S%';

3. Result

┌──────────────────────────┬───────────────┐
│     department_name      │   location    │
├──────────────────────────┼───────────────┤
│ Research and Development │ San Francisco │
│ IT Support               │ Seattle       │
│ Product Management       │ San Francisco │
└──────────────────────────┴───────────────┘