Tell me about your experience building Salesforce features using Apex, Lightning Web Components (LWC), and the Salesforce data model.
Using the supplied Salesforce-style Account, Contact, and Opportunity data, write a PostgreSQL query that summarizes account activity.
account_name, won_revenue, contact_count, and account_status.Won Business, Contacts Only, or No Activity.won_revenue descending, then account_name ascending.| Column | Type | Description |
|---|---|---|
| account_idPK | INT | Salesforce Account identifier |
| account_name | VARCHAR(120) | Account display name |
| owner_name | VARCHAR(120) | Assigned Salesforce account owner |
| industry | VARCHAR(80) | Account industry classification |
| created_date | DATE | Date the Account was created |
| Column | Type | Description |
|---|---|---|
| contact_idPK | INT | Salesforce Contact identifier |
| account_id | INT | Related Account identifier |
| full_name | VARCHAR(120) | Contact full name |
| VARCHAR(180) | Contact email address | |
| is_primary | BOOLEAN | Whether the Contact is marked primary |
| Column | Type | Description |
|---|---|---|
| opportunity_idPK | INT | Salesforce Opportunity identifier |
| account_id | INT | Related Account identifier |
| stage | VARCHAR(40) | Opportunity sales stage |
| amount | NUMERIC(12,2) | Opportunity amount |
| close_date | DATE | Expected or actual close date |