How to create a SELECT statement involving a subtype
How you do the select depends on your table design.  Your EER depicts the entities, relationships and attributes nicely, but doesn't say anything about table design.  (That's as it should be, IMO).  A relational schematic would give those details.

If you are interested in how to design tables for a subtype (or subclass) situation here are two alternative techniques for you to explore:

http://www.martinfowler.com/eaaCatalog/singleTableInheritance.html
http://martinfowler.com/eaaCatalog/classTableInheritance.html

And there is a technique often used when tables have a one to one relationship to each other.  You can see it here:

https://stackoverflow.com/questions/tagged/shared-primary-key