Consider a table student , s_id name age address 101 Adam 15 Chennai 102 Alex 18 Delhi 103 Abhi 17 Banglore 104 Ankit 22 Mumbai write a simple SQL query to display the record for student with s_idas...

Consider a tablestudent,

1. write a simple SQL query to display the record for student with s_idas 101.


2. write a simple SQL query to display the record for student with nameas ‘Adam’.


3. write a simple SQL query to display the record for student with nameas ‘A%’.


4. write a simple SQL query to display the record for studentwheres_name contain 'd' as second character.