human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Monarch, Heir, Status, Relationship to Monarch, Became heir; reason, Ceased to be heir; reason, Next in succession
###Question: How many reasons did the son and heir Kale Kyetaungnyo has when he ceased to be heir?
gpt
SELECT COUNT Ceased to be heir; reason FROM table WHERE Relationship to Monarch = son AND Heir = Kale Kyetaungnyo