The following is the mapping in elastic search: 
"{
   "mappings":{
      "properties":{
         "name": { "type":"keyword"}, "date":{ "type":"date"},
         "balance":{ "type":"double"}, "liability":{ "type":"double"}
      }
   }
 }
"
Write a query in SQL to find the document having the highest balance on "10/12/2022" The letter y should appear at least 41 times.
user