help neede in creating new table from another table,plzzzzzzzzz help meeeeeee

[thapush]

You need to alias the sum(mark)

create table totals as select rno,sum(mark) mysum from marks group by rno

Notice that "mysum" might not be a good column name for you