Hi Kingen,
You are trying the SQL queries in WQL Query tab. 'Queries' feature uses WQL queries which is the same used for SCCM Collection queries. Repoprting feature works on SQL. The queries given above are all SQL based and you need to try the same on the Reporting feature of SCCM.
Regards,
Rajeesh
http://scorpits.blogspot.com