I have tried but not able to create caml query for same. I have used Caml designer for same but unable to get proper result.

     Following is the Caml Query which is generated by using Caml designer but it is not giving results
  <Where>
  <And>
     <And>
        <And>
           <Eq>
              <FieldRef Name='Metadata_x0020_Name' />
              <Value Type='Lookup'>Author 1</Value>
           </Eq>
           <Eq>
              <FieldRef Name='Value' />
              <Value Type='Text'>Nitin Jagtap</Value>
           </Eq>
        </And>
        <Eq>
           <FieldRef Name='Metadata_x0020_Name' />
           <Value Type='Lookup'>Program</Value>
        </Eq>
     </And>
     <Eq>
        <FieldRef Name='Value' />
        <Value Type='Text'>MBA</Value>
     </Eq>
  </And>

I have a list having name “Metadata Values” which contains two columns