Assignment On SQL - XII CS
Assignment on SQL 1. The name column of a table 'student' is given below. Name Anu Sharma Rohan Saini Deepak Sing Kannika Goal Kunal Sharma Based on the information, find the output of the following queries: - Select name from student where name like "%a" - Select name from student where name like "%h%"; 2. Shopkeeper needs to change the first name of one of his customers in table 'customer'. Which command should he use for the same? 3. While creating table 'customer', Rahul forgot to add column 'price'. Which command is used to add new column in the table. Write the command to implement the same. 4. Surpreeth wants to add two more records of customer in customer table. Which command is used to implement this? 5. ...