{"absolute_url": "/jbmckee/sum-of-not-null-values/", "blog_post": false, "code": "select count(*) as totalsent, sum(opened is not null) as opened, round((sum(opened is not null)/count(*))*100) openperc, sum(clicked is not null) as clicked, round((sum(clicked is not null)/sum(opened is not null))*100) clickperc\n", "created": "2018-04-20T13:19:03.380906", "description": "", "description_rendered": "", "embed_url": "https://snipt.net/embed/3ec2b73c60eba7468418c6d08ad753ee/", "full_absolute_url": "/jbmckee/sum-of-not-null-values/", "id": 56, "lexer": "text", "line_count": 2, "log_entries": [{"code": "select count(*) as totalsent, sum(opened is not null) as opened, round((sum(opened is not null)/count(*))*100) openperc, sum(clicked is not null) as clicked, round((sum(clicked is not null)/sum(opened is not null))*100) clickperc\n", "created": "2018-04-20T13:19:03.976602", "diff": "--- \n+++ \n@@ -0,0 +1 @@\n+select count(*) as totalsent, sum(opened is not null) as opened, round((sum(opened is not null)/count(*))*100) openperc, sum(clicked is not null) as clicked, round((sum(clicked is not null)/sum(opened is not null))*100) clickperc\n", "user": "jbmckee"}], "meta": "", "modified": "2026-04-20T06:23:45.876441", "publish_date": "2018-04-20T13:19:03.129729", "raw_url": "/raw/3ec2b73c60eba7468418c6d08ad753ee/", "resource_uri": "/api/public/snipt/56/", "slug": "sum-of-not-null-values", "stylized": "<table class=\"highlighttable\"><tr><td class=\"linenos\"><div class=\"linenodiv\"><pre><a href=\"#L-1\">1</a></pre></div></td><td class=\"code\"><div class=\"highlight\"><pre><span></span><span id=\"L-1\"><a name=\"L-1\"></a>select count(*) as totalsent, sum(opened is not null) as opened, round((sum(opened is not null)/count(*))*100) openperc, sum(clicked is not null) as clicked, round((sum(clicked is not null)/sum(opened is not null))*100) clickperc\n</span></pre></div>\n</td></tr></table>", "tags": [{"absolute_url": "/public/tag/mysqli/", "id": 1, "name": "mysqli", "resource_uri": "/api/public/tag/1/", "snipts": "/api/public/snipt/?tag=1"}, {"absolute_url": "/public/tag/mysql/", "id": 18, "name": "mysql", "resource_uri": "/api/public/tag/18/", "snipts": "/api/public/snipt/?tag=18"}, {"absolute_url": "/public/tag/sql/", "id": 22, "name": "sql", "resource_uri": "/api/public/tag/22/", "snipts": "/api/public/snipt/?tag=22"}], "title": "Sum of not null values", "user": {"absolute_url": "/jbmckee/", "email_md5": "f4da96308b6db1b0b19738a7c105d3da", "id": 1, "resource_uri": "/api/public/user/1/", "snipts": "/api/public/snipt/?user=1", "snipts_count": 72, "username": "jbmckee"}}