SWQL Newbie direction and examples help

Have some sql experience from working with OpenNMS, but SWQL for some reason is not sinking in.

Example

SELECT TOP 5000 CustomPollerID, UniqueName, Description, OID, MIB, SNMPGetType, NetObjectPrefix, GroupName, PollerType, CustomPollerParserID, Format, Enabled, IncludeHistoricStatistics, Unit, TimeUnitID, TimeUnitQuantity, DefaultDisplayTimeUnitID, LastChange, PollInterval, ColumnNumber FROM Orion.NPM.CustomPollers
The above is from SWQl studio, nice to be able to see all the tables :-)
What is killing me is SWQL use of WHERE.
From the above  I want to do something like
SELECT Value of Orion.NPM.CustomPollerStatus.Rate WHERE UniqueName FROM Orion.NPM.CustomPollers =XXXX

Any specific reading materials or training material that anyone can point me to would be great, any comparable examples of use of SWQL would be helpful as well.
Thanks
Ted