Software Development

const UserProfile = ({ user }) => {
  const [loading, setLoading] = useState(false);

  return (
    <div className="user-profile">
      <Avatar src={user.avatar} />
      <h2>{user.name}</h2>
      <p>{user.email}</p>
    </div>
  );
};

@app.get("/users/{user_id}")
async def get_user(user_id: int):
    user = await User.get(user_id)
    if not user:
        raise HTTPException(404)
    return UserResponse.from_orm(user)

SELECT u.name, u.email, COUNT(p.id) as projects
FROM users u
LEFT JOIN projects p ON u.id = p.user_id
WHERE u.created_at > '2024-01-01'
GROUP BY u.id, u.name, u.email;