Counting Package Registries

Problem

Table `Packages` lists software dependencies. Each row has a `pkg_id` and a `coordinate` string written as `name@registry`, for example `parser@npmjs.org`. The part before the `@` is the package name; the part after the `@` is the registry host.

Consider only coordinates whose registry host ends in `.org`. For those, extract the registry host and count how many packages come from each one.

Return `registry` (the host after the `@`) and `pkg_count` (the number of packages from that registry), ordered by `registry` ascending.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns registry, pkg_count.

Starter code (SQL)

SELECT *
FROM Packages;

Related SQL questions

• Above-Average CampusesEasy
• Adjacent Open Parking SpotsEasy
• App Ad Click-Through RateEasy
• Asset Labels With a Three-Digit CodeEasy
• Average Listening Sessions per ListenerEasy
• Average Nightly Rate Earned per RoomEasy