WinWire Technologies Interview Question

Write the Codes in SQL?