Felipe Grolla
>Desenvolvedor de Software
SQL Query
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;Python Function
def process_user_data(user_id: int) -> dict:
user = db.query(User).get(user_id)
if not user:
raise ValueError(f"User {user_id} not found")
return {
"id": user.id,
"name": user.name,
}JavaScript Function
async function fetchUserProjects(userId) {
try {
const response = await fetch(
`/api/users/${userId}/projects`
);
return await response.json();
} catch (error) {
console.error('Failed to fetch:', error);
}
}@Grolla05