query excel from vbscript

i succed in query number of rows in excel file, but i can't make a query on certin column, or get the value of certin column ,
this is the code i have

Const adOpenStatic = 3 
Const adLockOptimistic = 3 

filename = "D:\temp\rbsupport\final\file.xls" 
Set cn = CreateObject("ADODB.Connection") 
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filename & ";Extended Properties=Excel 8.0" 

query = "Select count(*) as cnt from [internal$A4:B9] " 
Set rs = CreateObject("ADODB.Recordset") 
rs.Open query, cn, adOpenStatic, adLockOptimistic 

Do Until rs.EOF 
  WScript.Echo rs.Fields.item(0) 
  rs.MoveNext 
Loop

what do i need to change to make a group by on certin columns, or just to make a select on certin columns
thanks
Peleg

If you don't have column headers, you will need to use F1, F2 etc to refer to the fields you want according to their position.

thnaks alot
that what i was looking for, the default alias name of the column which starts with "F"