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!