LLamaRecipes/recipes/3p_integrations/groq/groq-example-templates/verified-sql-function-calling/verified-queries/most-recent-purchases.yaml

description: Five most recent purchases
sql: |
  SELECT purchases.product_name,
         purchases.amount,
         employees.name
  FROM purchases.csv AS purchases
  JOIN employees.csv AS employees ON purchases.employee_id = employees.employee_id
  ORDER BY purchases.purchase_date DESC
  LIMIT 5;