If you have done a SQL course it will have covered how to do this; you have just not fully understood.

I reccommend you read books by Itzik Ben-Gan starting...