Inserting data in tables
52.8
Exercise

Inserting records in specific columns

Write an SQL statement to insert 3 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) marks (INTEGER)
19 Bubbles 32
20 Buttercup 65
21 Blossom 97

Note: Try using the specific columns syntax of INSERT INTO statement for better understanding.