---

SELECT
    o.id AS order_id,
    o.order_time,
    o.total_amount,
    o.payment_method,
    b.full_name
FROM orders o
JOIN baristas b ON o.barista_id = b.id
WHERE DATE(o.order_time) = CURRENT_DATE;