Agentic AI Data Analyst & SQL Engine
Natural Language to Read-Only SQL Translator & Executive Insights
Read-Only Safety Enforcer Active
AI Executive Insight Summary
July 2026 total portfolio gross revenue reached $184,950.00 across 14 active properties. Waterfront Luxury Condo #4B delivered the highest yield at $28,450.00.
Generated Read-Only SQL:142 ms execution
SELECT p.title AS property, SUM(r.total_amount) AS gross_revenue, COUNT(r.id) AS total_bookings FROM properties p JOIN reservations r ON r.property_id = p.id WHERE r.created_at >= '2026-07-01' GROUP BY p.title ORDER BY gross_revenue DESC;
Query Output Table
| Property Title | Gross Revenue | Total Bookings |
|---|---|---|
| Waterfront Luxury Condo #4B | $28,450.00 | 8 |
| Mountain View Chalet #12 | $22,100.00 | 6 |
| Downtown Executive Loft #3 | $19,800.00 | 7 |