Skip
Arish's avatar

285. Practice - Copy Data 2

Exercise: Copy High Scorers

Copy students with marks > 90.

Solution

sql
1INSERT INTO honor_roll (name, marks)
2SELECT name, marks FROM students WHERE marks > 90;