SELECT date, get_json_object(json_col, '$.estudents[0].id_student') AS id_student, get_json_object(json_col, '$.estudents[0].score') AS score FROM your_table WHERE get_json_object(json_col, '$.estudents[0].score') RLIKE '\\.'