```sql revenue_over_time
select date_trunc('month', order_date) as month, sum(sales) as revenue
from orders
group by 1
order by 1

### Stacked Area Chart

```markdown
```sql revenue_by_category
select 
  date_trunc('month', order_date) as month,
  category,
  sum(sales) as revenue
from orders
group by 1, 2

### 100% Stacked Area Chart

```markdown
<AreaChart 
  data={revenue_by_category} 
  x="month" 
  y="revenue" 
  series="category"
  type="stacked100"
  title="Revenue Distribution"
  yFmt="pct"
/>

<AreaChart 
  data={revenue_over_time} 
  x="month" 
  y="revenue"
  line="true"
  fillOpacity=0.3
  yFmt="usd"
/>

<AreaChart 
  data={revenue_by_category} 
  x="month" 
  y="revenue" 
  series="category"
  colorPalette={['#4F46E5', '#7C3AED', '#DB2777']}
  fillOpacity=0.6
  markers="true"
  yGridlines="true"
/>

<AreaChart 
  data={inventory_levels} 
  x="date" 
  y="quantity"
  step="true"
  stepPosition="end"
  title="Inventory Levels"
/>