title: How to get the last updated specific column values using mysql?
body: <p>I am trying to manipulate the sql statement.</p>
  <p>Below is the table.</p>
  <pre><code>CREATE TABLE MY_TABLE (
      LOG_TIME    VARCHAR(14)   NOT NULL  
    , USR_ID      VARCHAR(10)   NOT NULL      
    , INFO_1     VARCHAR(20)   NULL 
    , INFO_2     VARCHAR(20)   NULL     
    , INFO_3     VARCHAR(20)   NULL          
    , PRIMARY KEY (LOG_TIME)
  )
  </code></pre>
  <p>After inserting some records as shown below,</p>
  <pre><code>LOG_TIME            USR_ID       INFO_1       INFO_2       INFO_3
  20220305010101      USER_1       MALE         -            -
  20220305022554      USER_1       -            BANGKOK      BASKETBALL
  20220305052554      USER_1       -            -            BASEBALL
  20220306010101      USER_2       -            SEOUL        BASEBALL
  20220306022554      USER_2       -            TOKYO        -
  20220307052554      USER_2       FEMALE       -            SOCCER
  
  </code></pre>
  <p>What I want to extract is that something like as shown below.</p>
  <pre><code>USER_ID       first_time            INFO_1       INFO_2         INFO_3    
  USER_1        20220305010101        MALE         BANGKOK        BASEBALL
  USER_2        20220306010101        FEMALE       TOKYO          SOCCER
  </code></pre>
  <p>Above table indicates that the latest updated values can be seen for INFO_1, INFO_2, INFO_3 and the oldest values for LOG_TIME for each user.</p>
  <p>How to achieve this sql statement?</p>