to find the common records

[Ayeshasaba_21]

Group	Area	Vendor
Group 1	Area 1	Vendor 1
Group 2	Area 1	Vendor 1
Group 3	Area 1	Vendor 1
Group 4	Area 1	Vendor 1
Group 5	Area 1	Vendor 1
Group 6	Area 1	Vendor 1
Group 7	Area 1	Vendor 1
Group 8	Area 1	Vendor 1
Group 9	Area 1	Vendor 1
Group 10	Area 1	Vendor 1
Group 11	Area 1	Vendor 1
Group 12	Area 1	Vendor 1
Group 13	Area 1	Vendor 1
Group 14	Area 1	Vendor 1
Group 15	Area 1	Vendor 1
Group 16	Area 1	Vendor 1

Group	Area	Vendor
Group 27	Area 2	Vendor 2
Group 28	Area 2	Vendor 2
Group 29	Area 2	Vendor 2
Group 30	Area 2	Vendor 2
Group 6	Area 2	Vendor 2
Group 7	Area 2	Vendor 2
Group 8	Area 2	Vendor 2
Group 9	Area 2	Vendor 2
Group 10	Area 2	Vendor 2
Group 36	Area 2	Vendor 2
Group 37	Area 2	Vendor 2
Group 38	Area 2	Vendor 2
Group 39	Area 2	Vendor 2
Group 40	Area 2	Vendor 2

The problem statement id to find :

1=groups that are present in area 1 vendor 1 not in area2 vendor2?

2=​groups that are present in area2 vendor2not in area 1vendor1?

3=how many groups are there for each area and vendor?

[Ayeshasaba_21]

guys please answer