Comparison use SQL SELECT on sql server oracle and mysql

Question

Greetings,

 

can someone please help me with this topic, i have experience with oracle but not with other two and need to make comparison for my college work !?

 

thank you.