LLamaRecipes/recipes/3p_integrations/groq/groq-example-templates/verified-sql-function-calling/verified-queries/number-of-teslas.yaml

description: Number of Teslas purchased
sql: |
  SELECT COUNT(*) as number_of_teslas
  FROM purchases.csv AS p
  JOIN employees.csv AS e ON e.employee_id = p.employee_id
  WHERE p.product_name = 'Tesla'