WQL for getting systems where last logon user is particular value for 'office' attribute

See more:

SQL

script

I need to make a membership rule for a device collection in System Center Configuration Manager 2012 R2, using WQL. I want to get all the devices where the last logon user has a given value for the 'office' AD attribute. I'm stuck.

There is another query I also can't get to work, though I don't understand why not. This query has to get all the systems where the bios date is under 30/09/2008. Here is what i tried.

SELECT SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, 
SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, 
SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client

from SMS_R_System inner join SMS_G_System_PC_BIOS 
on SMS_G_System_PC_BIOS.ResourceId = SMS_R_System.ResourceId

where SMS_G_System_PC_BIOS.ReleaseDate <= "30/09/2008 0:00:00"