SELECT
    p.first_name AS "First Name",
    p.last_name AS "Last Name",
    COUNT(r.sport_id) AS "Number of Sports Registered"
FROM
    player p
JOIN
    registration r
        ON p.player_id = r.player_id
WHERE
    r.payment_status = 'Paid'
    AND YEAR(r.reg_date) = 2024
GROUP BY
    p.player_id,
    p.first_name,
    p.last_name
ORDER BY
    p.first_name;

import java.util.*;

class UserMainCode {

    public int sumTransformedArray(int input1, int[] input2) {

        if (input1 == 0)
            return 0;

        Map<Integer, Integer> m = new HashMap<>();
        for (int x : input2)
            m.put(x, m.getOrDefault(x, 0) + 1);

        int s = 0;
        boolean f = false;

        for (int x : input2) {

            int l = 0;
            int g = 0;

            for (int y : input2) {
                if (y < x) l++;
                if (y > x) g++;
            }

            if (l == g && m.get(x) < 3) {
                s += x;
                f = true;
            }
        }

        if (!f) {
            long ts = 0;
            for (int x : input2)
                ts += x;
            return (int) ts;
        }

        return s;
    }
}

🚀 ACCENTURE OFF-CAMPUS | SUCCESS STORY ✅

Cognizant aptitude Slots available

COGNIZANT Technical Slots are available

Book your slots now

Dear Accenture Aspirants,

Successfully cleared Accenture ✓

Cognizant aptitude Slots are available