SELECT 
  "smoker", 
  AVG("tip" / "total_bill" * 100) AS percent_tip
FROM @kaggle.saurabhbadole_restaurant_tips_dataset.tips
GROUP BY "smoker"