SHOW:
|
|
- or go back to the newest paste.
| 1 | - | SELECT title, |
| 1 | + | SELECT first_name, |
| 2 | - | rental_rate, |
| 2 | + | last_name, |
| 3 | - | CASE |
| 3 | + | country |
| 4 | - | WHEN rental_rate < 1 THEN 'категория 1' |
| 4 | + | FROM CLIENT |
| 5 | - | WHEN rental_rate >= 1 |
| 5 | + | WHERE (company, |
| 6 | - | AND rental_rate < 3 THEN 'категория 2' |
| 6 | + | state, |
| 7 | - | WHEN rental_rate >= 3 THEN 'категория 3' |
| 7 | + | phone, |
| 8 | - | END |
| 8 | + | fax) IS NULL; |
