Inserting data in tables
52.6
Exercise

Inserting multiple records

Write an SQL statement to insert 4 new rows of records in the table students, as per the information below. Use a single INSERT query to achieve the solution.

id (INTEGER) name (TEXT) age (INTEGER) grade (INTEGER) course (TEXT) marks (INTEGER)
19 Arthur 16 10 32
20 John 15 9 Ruby 65
21 Ada 14 8 Java 97
22 Finn 13 7 SQL 42