Company: Wells_Frago_IIT_kgp
Difficulty: medium
Active Domains by Country Generate a report listing the countries with active domain registrations and the total number of active domains registered from each country, for strategic planning and market analysis. The report must include: country_name - the name of the country from which the domain was registered; total_domains - the total number of active domains registered from that country. Results must be sorted in ascending order by country_name . Only active domains are included in the result. Table: domains (inferred -- the original screen hides the schema behind a collapsed "Schema" panel; this single-table layout is the one the question has always been tested with.) Column Type Description id INTEGER Primary key country_name TEXT Country from which the domain was registered (never NULL) domain_name TEXT The registered domain name (unique, never NULL) status TEXT One of active , inactive , expired , suspended , pending (always lowercase) Expected Output Return exactly these two c