Is it possible in Email Studio's Tracking > Sends tab to get the device/platform info e.g. a pie chart on the devices on which the email was opened or clicked?
Otherwise is this possible through Automation Studio's SQL Query activity?
Device stats are not available via any standard data view. You can, however, do a data extract activity in automation studio which can be configured to include this using the check box "user agent"
There are three avenues to get the information you're after:
1) Return Path Integration
2) Discover Reports in Analytics Builder
3) Tracking Extract in Automation Studio