Question

consider the following "student" table and write the queries
║≈≈≈≈≈≈║≈≈≈≈≈≈║≈≈≈≈≈≈≈║≈≈≈≈≈≈≈║
║roll no ║name ║marks 1 ║marks 2 ║
║1 ║raj ║54 ║66 ║
║2 ║ram ║44 ║77 ║
║3 ║roshni ║77 ║79 ║
║4 ║rohan ║23 ║98 ║
║≈≈≈≈≈≈║≈≈≈≈≈≈║≈≈≈≈≈≈≈║≈≈≈≈≈≈≈║
1. to create the given table.
2. to display only name and marks 1 from table.
3. to insert one more row (5,"resham",55,76).
4. to delete the record of those student who are having marks 1 less than 30.
5. to update the maeks 1 and 49 of those student who secured marks less than 30.
*please answer*

Answer 1

Answer:

1. create table student (roll no. integer ,name varchar(20),marks1 integer,marks2 integer)
2. select name, marks from student
3. insert into table name (field 1,field 2...field n)values(value1 value2..value n)   [you haven't specified what to insert]
4. delete from student where marks 1 < 30
5. i didn't understand the question written as there is a syntax error

Explanation:

[the words which are underlined should be typed in capital]