Skip to content

Instantly share code, notes, and snippets.

@jcjones

jcjones/AvgNumberOfNames.sql

Created February 21, 2016 04:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jcjones/947ac15de9f308db6ea8 to your computer and use it in GitHub Desktop.
Save jcjones/947ac15de9f308db6ea8 to your computer and use it in GitHub Desktop.
Download ZIP
How many DNS Names are, on average, in each certificate issued by Let's Encrypt?
Raw
AvgNumberOfNames.sql
SELECT
AVG(count)
FROM
(SELECT
c.certID,
(SELECT
COUNT(n.name)
FROM
name AS n
WHERE
n.certID = c.certID) AS count
FROM
le_current_certificate AS c) AS a;
Raw
AvgNumberOfNames.tsv
We can make this file beautiful and searchable if this error is corrected: No tabs found in this TSV file in line 0.
AVG(count)
3.7804
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment