CPU Score

[elsbrock]

WITH device_data AS (
  SELECT 
    device.name AS cpu_name,
    device.score,
    device.multicore_score
  FROM (
    SELECT unnest(devices) AS device
    FROM read_json('https://browser.geekbench.com/processor-benchmarks.json')
  )
)
SELECT s.cpu, d.score, d.multicore_score
FROM server s
JOIN device_data d ON LEFT(s.cpu, 3) = LEFT(d.cpu_name, 3)
WHERE levenshtein(lower(s.cpu), lower(d.cpu_name)) <= 3
ORDER BY levenshtein(lower(s.cpu), lower(d.cpu_name))
LIMIT 1;

Need to research on the terms of the data.