Sinara interview question

Some basic SQL questions, i.e 'what would this query print' with some tables for reference and then a question regarding 'if i wanted to print somehting else, how would i do it'