How we can application IN statement that in SQL with JSON query?

[MuhmdHsn313]

The Question

How we can application IN statement that in SQL with JSON query?

If I have a people table, and it has a column of JSON data type, and this column contains a key with the title age representing the age of the person, like

{
   "age": 24
}

How can I get people within a range of ages? i.e. how to apply IN that in SQL to a JSON stored in the database?