Sample SQL script to fix the data

Experts

In Account screen i added a custom field called Day:And the value is pick mapping based on status and sub status piclist values.The day value defined in the LOV table.

example : in LOV table i have data like this

LOV type            Value              Parent LIC             custom value

CX_TYPE        Open-west            Open                           5

In account screen,  when status,picked by open and sub status picked by Open-west, the Day field populated with value as 5.

I am trying to build a sql script to update the existing account records where Day value are null.

how to populate this value from LOV table using  a sql script..