Felipe Grolla

SELECT u.id, u.username,
  COUNT(p.id) AS total
FROM users u
LEFT JOIN projects p
  ON u.id = p.user_id
GROUP BY u.id;

def get_active_projects(user_id: int) -> list[dict]:
    """Fetch projects with recent commits."""
    db = Database()
    return db.query("SELECT * FROM projects WHERE active = 1")

async function loadUserData(userId) {
  try {
    const response = await fetch(`/api/users/${userId}/projects`);
    return await response.json();
  } catch (error) {
    console.error('Failed:', error};
}