Question: Please write SQL queries for this question, not the explanation or the flowchart, just the sql queries for this question. Thanks 4. Write SQL statements
Please write SQL queries for this question, not the explanation or the flowchart, just the sql queries for this question. Thanks

4. Write SQL statements for the following: Create a table sub with following information: columns and data types: name varchar(8), age number(5), markl number(4), mark2 number(4), mark3 number(4); a. Enter at least five tuples for the given relation. b. Add one more column with field name as total with data type as number(5). c. Update the age of sub for a particular student. d. Deleting a row from the table. e. Drop column mark3. f. Modify the table by changing the data type of mark3 to number(6) g. Delete all the data from the sub table. h. Delete the table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
