使用SQL解析JSON：如何在JSON对象中提取记录？

I'm looking at about 13,000 rows in a SQL Server table, and trying to parse out certain values within one column that is stored as json.I'm looking at about 13,000 rows in a SQL Serve