As Said above , Using Group by clause will help you in getting the results in a a pivot table format. just use the group by clause for all the...