Anyone know a good place to ask #sqlite or #sql questions?

I'm trying to convert rows (produced by a big query that then uses a GROUP BY advisory_type) that produces data like:

-- the `advisory_type` can be one of multiple values, i.e. SECURITY, DEPRECATED, UNSUPPORTED
repo    advisory_type  total_advisories
------  -------------  ----------------
jvt.me  SECURITY       10               
jvt.me  DEPRECATED     5               

And I'm trying to convert this to:

repo    total_security total_deprecated total_unmaintained
------  -------------  ---------------- ----------------
jvt.me  10             5                0               

Any clue how I'd go about doing so? Happy to provide more details / some data for you to query too, but been playing around with it on and off and not really having any luck.

Also on:

This post was filed under notes.

Interactions with this post

Interactions with this post

Below you can find the interactions that this page has had using WebMention.

Have you written a response to this post? Let me know the URL:

Do you not have a website set up with WebMention capabilities? You can use Comment Parade.