SQL query

Hallo

I'm looking through the database tables & I'm not sure about the nomenclature.

What would be the sql query to select all devices with operating system = 'windows 2012'

Thanks!