By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| user_id | type | CASE WHEN ISNULL(C.revenues) = 1 THEN 0 ELSE C.revenues END |
|---|---|---|
| 101 | adventure | 30 |
| 101 | animate | 0 |
| 101 | comic | 10 |
| 101 | comic | 10 |
| 101 | romantic | 0 |
| 102 | adventure | 0 |
| 102 | animate | 0 |
| 102 | comic | 0 |
| 102 | romantic | 20 |