LLamaRecipes/3p-integrations/groq/groq-api-cookbook/json-mode-function-calling-for-sql/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