I explained a employee data where the salary data, personal data, positional hierarchy are in different tables and explained using select, order by, where and join in my example.