Practice · Science & Space · Medium
Count how many satellites Egypt launched with each partner. Return partner and a column named launches, most launches first, then partner alphabetically for ties.
Runs in your browser. No signup needed.
satellites(name, launch_year, purpose, partner). Use GROUP BY partner.
SELECT partner, COUNT(*) AS launches
FROM satellites
GROUP BY partner
ORDER BY launches DESC, partner;The reference solution is checked automatically when you run your query on the practice page — results are compared row by row, and order matters for this one.
MisrSat-2 (2023) was built with a ~$92m Chinese grant and locally assembled/tested — a deliberate step toward home-grown satellite manufacturing. (Space in Africa / CGTN)