Write a SQL query to join a table of company profiles with a table of shareholder meetings to find all meetings occurring in a specific quarter.
Assume the target quarter is Q2 2025. Include only meetings linked to a company profile and sort the results chronologically.
meeting_id, company_id, company_name, meeting_date, and meeting_type.meeting_date and meeting_id.| Column | Type | Description |
|---|---|---|
| company_idPK | INT | Unique company identifier |
| company_name | VARCHAR(150) | Registered company name |
| ticker_symbol | VARCHAR(12) | Public market ticker symbol |
| sector | VARCHAR(80) | Primary business sector |
| Column | Type | Description |
|---|---|---|
| meeting_idPK | INT | Unique shareholder meeting identifier |
| company_id | INT | Company associated with the meeting |
| meeting_date | DATE | Scheduled meeting date |
| meeting_type | VARCHAR(40) | Meeting classification |
| meeting_status | VARCHAR(30) | Current meeting status |