LLamaRecipes/3p-integrations/groq/groq-example-templates/verified-sql-function-calling/verified-queries/employees-without-purchases.yaml

description: Employees without a purchase since Feb 1, 2024
sql: |
  SELECT employees.name as employees_without_purchases
  FROM employees.csv AS employees
  LEFT JOIN purchases.csv AS purchases ON employees.employee_id = purchases.employee_id
  AND purchases.purchase_date > '2024-02-01'
  WHERE purchases.purchase_id IS NULL