I am trying to create a stored procedure to establish which user has upload the most videos on my site.
The tables are:
VideoNo, VideoName, UserNo, VideoUrl
UserNo, FirstName, LastName
Each entry on the video table uses the users number. I would like to return a query that gives me the userNo, FirstName, LastName and a new column with Total uploads of all their videos.
Is this possible?