Question

Mention any three features of a database system. Again, write queries to -

EmpDetails

EmpId     EName       ManagerId   DateOfJoining

 121      Mina Rout         321          01/31/2018

 321      John White       986          01/20/2017

 421      Manish Rana     876          27/12/2017

1. Write An SQL query to fetch the names of the employees who have joined in 2017.

2. Write a query to show the manager’s names.