All projects
In buildMobileAI
A-Inya
Nutrition app that helps you decide what to eat.
Problem
Deciding what to eat, every day, factoring in allergies and preferences, is a small but constant source of friction.
What I built
A nutrition app that helps you decide what to eat based on a personal profile — favourite meals, allergies, and preferences.
Stack
Mobile
The kind of code behind it
1SELECT
2 worker_id,
3 DATE_TRUNC('month', occurred_at) AS month,
4 COUNT(*) AS job_count,
5 SUM(amount) AS total_amount,
6 ROUND(AVG(confidence), 2) AS avg_confidence
7FROM work_records
8WHERE confidence >= 0.6
9GROUP BY worker_id, DATE_TRUNC('month', occurred_at)
10HAVING COUNT(*) >= 1
11ORDER BY worker_id, month DESC;