SQL SYNTAX QUESTION...PLEASE HELP!!?????????????

Are these to be done only in native SQL code or can a scripting language such as T-SQL or PL/SQL be used? Also, have you made an attempt yourself at what is obviously homework?