Find the Occurrence and Result of each occurrence

Dear Friends,

Here is my sheet attached contains two sheets:

Sheet 1: Standard query names in system
Sheet 2: Queries in Audit and Result columns

I would like to compare the sheet 2 Column A (SystemQueries from Audit) with Sheet 1 Column A (System queries) and get the number of occurrence of each queries fired at column B No. of Occurrence in Sheet 1 and the results on each occurrence in sheet 1 in the respective results columns.

Thanks in advance. It would be great of help.

Regards,
M.Suriyakumar