select  distinct  avg(r.rating), m.title, count(m.title) as countofMovies
from ratings r
inner join movies m
on m.movieid = r.movieid
group by m.title

quote:

---

Originally posted by jgonzalez14

I am trying to find out how many movies have been rated. This seems to do it but i just need a count and do not need any of these selections. The m.title column gives me a distinct list of the movies that have been rated. I need this count which is 58 rows. How can I do this so that my result is just this: Count of movies: 58.

select count(distinct m.title) as countofMovies
from ratings r
inner join movies m
on m.movieid = r.movieid

Any ideas?

---