Suppose I have two table X and Y and I want to compute the ratio of the number of rows in X and the number of rows in Y. What would be the SQL I could type into a psql session to get this number?
This is an example of the recurring problem of performing arithmetic using the result of various calls to count(*) (or other mathematic functions).
TIA!
Kynn