Windows 7 x86 and x64 Machine count from Query

[mark_sccm]

I am looking for a query that gives windows 7 x64 machines and x86 machine on SCCM console.
 

tried this 

1.select *  from  SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.SystemType = "x64-based PC"

2. select *  from  SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.SystemType = "x86-based PC"

Seems like this is not correct!. In that query I didn't mention server operating or windows 7 desktop version.

Appreciate your help in advance

[GarthMJ]

What is wrong with these? Did you add the OS as a criteria?