Data Retrival from Two Tables

Question

i want to display the no of courses available in each dept Pls Help me i want to print   courses for each department pls help me  This Is  MyTable