One question of sorting for a list of people belonging to different cities and states.

Question

Accepted Answer

Sort a list of people by their cities and states.

Use a sorting algorithm like quicksort or mergesort.
Create a custom comparator function that compares the city and state of each person.
If two people belong to the same city and state, sort them by their names.
Example: [{name: 'John', city: 'New York', state: 'NY'}, {name: 'Jane', city: 'Boston', state: 'MA'}]
Example output: [{name: 'Jane', city: 'Boston', state: 'MA'}, {name: 'John', city: 'New York', state: 'NY'}]

Accepted Answer

Is it sorting by state then city
Or something harder.

Accepted Answer

Sort a list of people by their cities and states. Use a sorting algorithm like quicksort or mergesort. Create a custom comparator function that compares the...

Accepted Answer

process management,memory management, file systems management, device management and security and privacy.

Accepted Answer

Hi

Accepted Answer

Assemble to cities one-sided and State another side

Accepted Answer

it in two parts. Let's also make the simplifying assumption (not stated in your question) that the Users table has only one entry per user per city.

Accepted Answer

Sorting and filtering are two tools that let you customize how you organize and view your data, making it more convenient to work with. In this lesson, you'll learn how to sort and filter records

Accepted Answer

Clt find option via key board - enter any of deta regarding your - enter.

Accepted Answer

Name of the person, Pincode.you can type the various pincode provided and you can find the places and details

Accepted Answer

move to excel apply there welookup formula and you will get answer to ur Question .

Accepted Answer

it in two parts. Let's also make the simplifying assumption (not stated in your question) that the Users table has only one entry per user per city.

Accepted Answer

Go to excel put formula n filter it out..

Accepted Answer

Sorting Data by State then City

Accepted Answer

If u have data ready it's Very simple go to excel put formula n filter it out.

Accepted Answer

then we have to identify blaming that.it is possible.

Accepted Answer

If u have data ready it's Very simple go to excel put formula n filter it out.

Accepted Answer

Assemble to cities one-sided and State another side

Accepted Answer

· Let ABCDE for persons assume PQRST different city/ state

· If A is from city P

· B is from city Q

· C is from city R

· D is from city S

· E is from city T

Assume depending on the alphapetical order of the city/ state the persons can be sorted accordingly.

Accepted Answer

If u have data ready it's Very simple go to excel put formula n filter it out.

Accepted Answer

it in two parts. Let's also make the simplifying assumption (not stated in your question) that the Users table has only one entry per user per city.

Accepted Answer

Some people live in the other cities and states are following .

Cities / states

Meerut / Uttar pardesh

Sonipat / Haryana

Surat / Gujrat

Shrinagar / Jammu and kashmir

Haridwar / uttarakhand

Accepted Answer

If u have data ready it's Very simple go to excel put formula n filter it out...

Accepted Answer

Sort a list of people by their cities and states.

Use a sorting algorithm like quicksort or mergesort.
Create a custom comparator function that compares the city and state of each person.
If two people belong to the same city and state, sort them by their names.
Example: [{name: 'John', city: 'New York', state: 'NY'], {name: 'Jane', city: 'Boston', state: 'MA']
Example output: [{name: 'Jane', city: 'Boston', state: 'MA'], {name: 'John', city: 'New York', state: 'NY']

Accepted Answer

If we have a data ready it's very simple go to excel put formula and filter it out.

Accepted Answer

Access sample base & cities and there pincode number

Accepted Answer

order sales data by calendar month so that you can produce a graph of sales performance.

Accepted Answer

Name of the city and pin code

Accepted Answer

If u have a data ready it's very simple go to excel put formu n filter it out.

Accepted Answer

Name of the city and pin code

Accepted Answer

This is really a two part question:

What cities have more than one user located in them?
What users live in that subset of cities?

Let's answer it in two parts. Let's also make the simplifying assumption (not stated in your question) that the Users table has only one entry per user per city.

Accepted Answer

SELECT id, name, city

FROM persons

JOIN (SELECT city

FROM persons

GROUP BY city HAVING count(*) > 1) AS cities

USING (city);

Accepted Answer

My Answer is

Sort a list of people by their cities and states.

Use a sorting algorithm like quicksort or mergesort.
Create a custom comparator function that compares the city and state of each person.
If two people belong to the same city and state, sort them by their names.
Example: [{name: 'Mark', city: 'Abu Dhabi', state: 'AD'}, {name: 'Carl', city: 'New York', state: 'NY'}]
Example output: [{name: 'Carl', city: 'New York', state: 'NY'}, {name: 'Mark', city:NeAbu Dhabi', state: 'AD'}]

Accepted Answer

Sorting alphabetically (AtoZ or Z to A) by value ( largest to smallest or smallest to largest) by day of the week ( Monday, Tuesday, Wednesday, Thursday, Friday........) Or by month names ( Jan,Feb......).

Accepted Answer

My Answer is

Sort a list of people by their cities and states.

Use a sorting algorithm like quicksort or mergesort.
Create a custom comparator function that compares the city and state of each person.
If two people belong to the same city and state, sort them by their names.
Example: [{name: 'Mark', city: 'Abu Dhabi', state: 'AD'}, {name: 'Carl', city: 'New York', state: 'NY'}]
Example output: [{name: 'Carl', city: 'New York', state: 'NY'}, {name: 'Mark', city:NeAbu Dhabi', state: 'AD'}]

Accepted Answer

India is home to a vast array of cities, each with its own unique culture and history. From the bustling metropolises of Mumbai and Delhi to the ancient cities of Varanasi and Jaipur

Accepted Answer

If u have data ready it's Very simple go to excel put formula n filter it out

Accepted Answer

People name, state pincode or city pincode or any proof

Accepted Answer

If u have data ready it's Very simple go to excel put formula n filter it out.

Accepted Answer

Area pincode and state pincode

Accepted Answer

Making a list for all people and than short by function list.short([name of people] )

Accepted Answer

Sort a list of people by their cities and states.

Use a sorting algorithm like quicksort or mergesort.

Create a custom comparator function that compares the city and state of each person.

If two people belong to the same city and state, sort them by their names.

Example: [{name: 'John', city: 'New York', state: 'NY'}, {name: 'Jane', city: 'Boston', state: 'MA'}]

Example output: [{name: 'Jane', city: 'Boston', state: 'MA'}, {name: 'John', city: 'New York', state: 'NY'}]

Accepted Answer

Excel put formula and filter it out it we can list the people

Accepted Answer

it's simply fo to exel put formula n then after filter it out

Accepted Answer

Filter the State or cities in alphabet order so that we can sort the list of people beloning to the correct state of cities

Accepted Answer

its simple fo to excel put formula n filter it out

Accepted Answer

If u have data ready it's Very simple go to excel put formula n filter it out.

Accepted Answer

If u have data ready it's Very simple go to excel put formula n filter it out.

Accepted Answer

Filter the State or cities in alphabet order so that we can sort the list of people beloning to the correct state of cities

Accepted Answer

Input:

Person 1: Name - John, City - New York, State - New York

Person 2: Name - Mary, City - Los Angeles, State - California

Person 3: Name - Sarah, City - New York, State - New York

Person 4: Name - Michael, City - Chicago, State - Illinois

Person 5: Name - John, City - New York, State - California

Output:

Person 5: Name - John, City - New York, State - California

Person 1: Name - John, City - New York, State - New York

Person 2: Name - Mary, City - Los Angeles, State - California

Person 4: Name - Michael, City - Chicago, State - Illinois

Person 3: Name - Sarah, City - New York, State - New York

One question of sorting for a list of people belonging to different cities and states.

Capgemini Software Engineer interview questions & answers

Popular interview questions of Software Engineer

Top HR questions asked in Capgemini Software Engineer