SQL: Conditional values according to one field
===

I have defined:  
**table X**

    ID    AGE    HEIGHT   REGISTERED
    1     23     1.83     1
    2     24     1.81     0
    3     24     1.72     0
    4     22     1.91     1
    5     32     1.76     0

And I would like to perform a query to return valid values but `*ONLY*` for the registered ID's. Those who are not, would get 0 in return. like this:

**result**

    ID    AGE    HEIGHT   REGISTERED
    1     23     1.83     1
    2     0      0        0
    3     0      0        0
    4     22     1.91     1
    5     0      0        0

What is the way of defining that query?
