using query function with importrange

Google spreadsheets support query easily.

If you use importrange, column position name was changed.

That's time, you can use 'col#' notation.

A is Col1, B is Col2 ...........

Condition syntax rules are same with general notations.