Row Number Simulation

Generate row numbers for each record in the 'Album' table. Importantly, do not use window functions to accomplish this.

Final Columns to Display: AlbumId, RowNumber
Order By: Results should be ordered by AlbumId.

To pass this challenge, your query should produce a result set with the columns AlbumId and RowNumber, where RowNumber represents the row number for each corresponding AlbumId. The result set should be ordered by AlbumId.