I wrote a SQl quesry to find "the higher hiredates from the minimum hiredate for those whose job='DBD'
. . . Etc ...
So you see I got every bodies hiredate whether it is 'DBD' or not. So what should be the right SQL query to display the right data?

The requirement is confusing, but if I understood correctly, it should be kinda like this: