To select a unique list of subscribers who have made multiple purchases, the developer should use the following SQL statement:
SELECTSubscriberKeyFROMOrdersGROUPBYSubscriberKeyHAVINGCOUNT(*)>1
This query groups the records by SubscriberKey and selects only those groups where the count of records is greater than one, indicating multiple purchases.
References:
* SQL GROUP BY Statement
* SQL HAVING Clause

To create a lead capture form on a landing page and create a Lead record in Salesforce, you can use either AMPscript or SSJS. AMPscript can be used for interacting with Salesforce, and SSJS can handle form processing. Alternatively, SSJS can handle the entire process, including creating the Salesforce record.
* AMPscript and SSJS Combination: You can use AMPscript to interact with Salesforce APIs to create
* records and SSJS for form handling.
* SSJS for Full Functionality: SSJS can handle both the form submission and the interaction with Salesforce to create Lead records.