Re: Dividing a count by another count

[Peter Brawley]

> I can't hard copy "Show Create Table"

Sure you can. Run the cmd in the mysql client program, terminate with with \G, copy the result, paste it here.

For your query, is this what you mean?

select round( avg(N), 1 ) as avg
from (
  select a.code_matricule, count(e.code_emprunt) N
  from abonne a
  join emprunt e using(code_matricule)
  group by code_matricule
) x;