Useful driver version telemetry SQL queries

driver_version_sql_queries

https://sql.telemetry.mozilla.org/queries/4438/source#8912

Most Popular NVIDIA Driver Versions
SELECT
    system_gfx[1].adapters[1].driver_version AS driver_version,
    COUNT(*) AS sample_count
FROM longitudinal_v20170422
WHERE
    system_gfx[1].adapters[1].vendor_id = '0x10de'
    AND system_os[1].version = '10.0'
    AND os = 'Windows_NT'
GROUP BY 1
HAVING COUNT(*) > 100
ORDER BY 2 DESC

Most Popular NVIDIA Driver Versions for the GT610
SELECT
    system_gfx[1].adapters[1].driver_version AS driver_version,
    COUNT(*) AS sample_count
FROM longitudinal_v20170422
WHERE
    system_gfx[1].adapters[1].vendor_id = '0x10de'
    AND system_os[1].version = '10.0'
    AND os = 'Windows_NT'
    AND system_gfx[1].adapters[1].device_id = '0x104a'
GROUP BY 1
HAVING COUNT(*) > 100
ORDER BY 2 DESC