Report for PCs with less than 1024MB RAM

[KKL]

Hi everyone.
Now I managed to create 2 report errors trying to create this report in Report Builder.

Does anyone have an idea of what my SQL should be for the following:

Hardware report that shows all PCs with names beginning with "XSS" and with less than 1GB RAM?

Thanks

[KKL]

Thanks a lot!

[Hemoco]

Select Top 100 Percent dbo.tblComputers.Computername As Computer,
  Cast(Cast(dbo.tblComputersystem.TotalPhysicalMemory As BigInt) / 1024 /
  1024 As Numeric) As Memory, dbo.tblComputers.Domain,
  dbo.tblComputersystem.Model, dbo.tblComputers.Lastseen
From dbo.tblComputers Inner Join
  dbo.tblComputersystem On dbo.tblComputers.Computername =
    dbo.tblComputersystem.Computername
Where dbo.tblComputers.Computername Like 'XSS%' And
  Cast(Cast(dbo.tblComputersystem.TotalPhysicalMemory As BigInt) / 1024 /
  1024 As Numeric) < 1000
Order By dbo.tblComputers.Computername