The conversation between human and AI assistant.
How do I write query to display the name of the company that manufactures the most number of medications?
I am using Microsoft SQL Server.
Alright, the query would be:

SELECT TOP 1 CompanyName
FROM Medications
GROUP BY CompanyName
ORDER BY COUNT(*) DESC;

This will display the name of the company that manufactures the most number of medications.