How to Extract Job Offers by Company from Two Tables

Hi Team, I need help with a task involving two tables: Table A, which contains job offers, including a column named "1A," and Table B, which lists companies. I would like to achieve the following:

1.
Extract the number of job offers in Table A that are associated with a specific company and meet a condition based on one of the values in column "1A."
2.
Display this information in Table B alongside the corresponding company.

Could you please guide me on how to implement this? Thank you!

2 comments