How to select rate for all selected modules and all selected years no matter they got rate for that year or not
That looks like a homework question that is investigating how well you understand outer joins and maybe the NVL function (rather than the equijoins you currently have).