Run this with root permission in your terminal.

apt-get install mysql-server

This will ask you for a password. Type 'password' there.

1. Create a 'camp' database
2. Create a 'students' table in it with the fields
   1. Name
   2. College
   3. District
   4. Email
   5. Age
   6. Year
   7. Semester
   8. Team number
   9. Branch
3. Insert atleast 10 records in it.
4. Retrieve all the students whose age is greater than 20
5. Retrieve all the students who are in 3rd year
6. Retrieve all the students who are in 4th,5th or the 6th team
7. Retrieve all the students who are in 2nd year, 2nd semester.
8. Retrieve all the students who are in ECE branch.
9. Retrieve all the students whose name starts with 'a' and ends with 'd'.
10. Create a table called 'favourites' it must have four fields
    1. Name
    2. Favourite Session 1
    3. Favourite Session 2
    4. Favourite Session 3
11. Now, Insert the records with the values of the 'Favourite Sessions' being any session in the camp that you like. For example I like 'python','git','communication-skills' so, I will insert ('ganesh','python','git','communication-skills').
12. Retrieve all the students who have 'python' as favourite 1.
13. Retrieve all the students who dont have 'databases' as favourite 2.
14. Retrieve all the students who have 'git' or 'documentation' as favourite 1.
15. Retrieve all the students who have 'python' as favourite 1, 'editors' as favourite 2, and 'databases' as favourite 3.
16. Update the email of a student in the 'students' table to '[email protected]' where the name is 'john' (Create a row with name = john for this.)
17. Find the number of students in students table.