Q-1.Create this table (Employee) and use Like command to execute the query


Id Name Department Salary Age Gender City
1001 John Doe IT 35000 Male 25 London
1002 Mary Smith HR 45000 Female 27 London
1003 James Brown Finance 50000 Male 28 London
1004 Mike Walker Finance 50000 Male 28 London
1005 Linda Jones HR 75000 Female 26 London
1006 Anurag Mohanty IT 35000 Male 25 Mumbai
1007 Priyanla Dewangan HR 45000 Female 27 Mumbai
1008 Sambhit Mohanty IT 50000 Male 28 Mumbai
1009 Pranaya Kumar IT 50000 Male 28 Mumbai
1010 Hina Sharma HR 75000 Female 26 Mumbai


  • Fetch all the employees whose names start with P.
  • Fetch all employee whose name contains the word am.
  • Fetch all the employees whose name does not start with P.
  • Fetch all the employees whose name does not end with ar.
  • Fetch all employee whose name does not contain the word am.
  • Fetch all the employee whose department is having two letters.
  • Add two columns with the name of Email and Commission in apropriate data types and update the values in email name@gmail.com and in Commission 25% of salary.