Problem: How to get correct CAML Query for a list?
Solution: Sometimes, we can use U2U CAML Query editor, but there is another method to identify the CAML query.
Step 1: Create a view on the list which you are planning to work on with all filters and conditions specified.
Step 2. Save the list as template and move the stp file to your local drive.
Step 3. Rename the file as .cab from .stp and extract to see the manifest.xml file.
Step 4. Search with the View name and you will find the query just below the found location.
Step 5. Copy and use it in your .net Coding