JSON stored in a column 'DataJson' in table [{ "KickOffDate": "1-Jan-2019", "TeamSize": "11", "ClientEngineer": "Sagar", "WaitingPeriod": "16.5" }] Query SELECT JSON_VALUE(DataJson,'$.…