How to add an integer to the result of SELECT COUNT()

Hi there,

The issue you’re facing is related to your SQL syntax.

Basically in SQL, you can’t directly divide the results of two SELECT COUNT() statements using the / operator like that.

Instead, you need to use subqueries or CROSS JOIN to combine the results of the two COUNT() queries and then perform the division.

Here’s how you can do it using a subquery:

You can use subqueries to first compute each COUNT() and then divide the results:

SELECT 
    (SELECT COUNT(id) FROM members) / 
    (SELECT COUNT(id) FROM orchestras) AS ratio;

Alternatively, you can use a CROSS JOIN to calculate the ratio in a single query:

SELECT 
    m.count_members / o.count_orchestras AS ratio
FROM 
    (SELECT COUNT(id) AS count_members FROM members) m
CROSS JOIN 
    (SELECT COUNT(id) AS count_orchestras FROM orchestras) o;

• Subquery Method: Each SELECT COUNT() is computed separately, and then the results are divided.
• CROSS JOIN Method: The CROSS JOIN combines the results of both COUNT() queries into a single row, where you can perform the division.

Make sure that the COUNT(id) in both tables doesn’t result in zero to avoid a division by zero error.

These approaches should resolve the syntax issue and allow you to calculate the ratio of the counts from the two tables.

- Bobby