SELECT
  COUNT(*) as total,
  COUNT(*) FILTER (WHERE resource_type = 'database') as databases,
  COUNT(*) FILTER (WHERE resource_type = 'tool') as tools,
  COUNT(*) FILTER (WHERE status = 'pending') as pending,
  COUNT(*) FILTER (WHERE status = 'approved') as approved,
  COUNT(*) FILTER (WHERE status = 'rejected') as rejected,
  COALESCE(AVG(score), 0) as avg_score,
  COUNT(*) FILTER (WHERE score > 0.7) as high_score
FROM discovered_resources

SELECT id, url, name, description, resource_type, metadata, score,
       discovered_at, last_seen_at, status
FROM discovered_resources
WHERE resource_type = $1 AND status = $2
ORDER BY score DESC, discovered_at DESC
LIMIT 200

SELECT id, domain, description, priority_score, status,
       url_count, approved_by, discovered_at
FROM discovered_domains
ORDER BY priority_score DESC
LIMIT 100