Asking ChatGPT to extract FIX message sequence number

I need to extract the FIX message sequence number from the FIX messages stored in the 'msg' column of a table in a MySQL database. In this video, I asked ChatGPT to write the query for me. After three back-and-forths, it gave me a correct and executable script.

Notes: This is probably the 10th recording. In previous sessions, ChatGPT sometimes provided the correct and executable query in the first response. I'd say 80% of the time, ChatGPT had some misses but was able to give me the correct SQL after receiving more information, as shown in this video.