Knowee
Questions
Features
Study Tools

Write a query to display person name,contact number and balance  of all the details, who are travelled maximum number of times. If there is multiple record dipsplay the record in descending order by person name.Note:1. Display only the  peron name, contact number and balance whose travelled maximum number of times.2. Order by is mandatory.3. Compare your executed result with the sample output given below.

Question

Write a query to display person name,contact number and balance  of all the details, who are travelled maximum number of times. If there is multiple record dipsplay the record in descending order by person name.Note:1. Display only the  peron name, contact number and balance whose travelled maximum number of times.2. Order by is mandatory.3. Compare your executed result with the sample output given below.

...expand
🧐 Not the exact question you are looking for?Go ask a question

Solution

It seems like you're asking for a SQL query. Here's a general structure of how you might write this query. Please replace the table and column names with your actual table and column names.

SELECT person_name, contact_number, balance
FROM your_table
WHERE travel_count = (
    SELECT MAX(travel_count)
    FROM your_table
)
ORDER BY person_name DESC;

In this query, we're selecting the person_name, contact_number, and balance from your table where the travel_count is equal to the maximum travel_count in the table. We're then ordering the results in descending order by person_name.

Please note that this query assumes you have a column travel_count in your table that records the number of times each person has traveled. If your table structure is different, you may need to adjust the query accordingly.

This problem has been solved

Similar Questions

Write a query to display the person name,contact number,balance,entry_time and exit_time details of all the persons who is having the second highest balance in their travel cards. Display the records in ascending order based on their person_name.Note:1. Display only the below 5 columns,     i. person name     ii. contact number      iii. balance     iv. entry time and      v. exit timewith the condition having second highest balance.2. Order by is mandatory.3. Compare your executed result with the sample output given below.

Write a query to display the person_name and contact_number from the 'travel_card'.Display the records in ascending order based on the person_name.Note:1. Display only the column named person_name and contact_number present in the travel_card table.2. Order by is mandatorySample output: [Only few records are shown here]

In a travel tracking application, you need to generate a report on the distance traveled by each user to evaluate their activity.Your task is to write a query that retrieves this information, presenting the users in descending order of traveled distance. In case of a tie, the users should be ordered by name in ascending order for a clear and organized travel summary.The Sample records are given belowInput format :The input records are already prepopulated, as given in the problem statement.Output format :The output should display the list of users along with the total distance they have traveled, sorted in descending order of traveled distance. If a user has not taken any rides, their total distance traveled is considered as 0 as shown below.The output is ordered by travelled_distance in descending order and then by name in ascending order as shown below.name travelled_distanceElvis 450Lee 450Bob 317Jonathan 312Alex 222Alice 120Donald 0Refer to the sample output for the column headers.

Write a query to display the person_name and the contact_number from travel_card table of every person whose destination station is on the route 'North East line' with the payment more than 25. Display the records in ascending order based on person name.Note:1. Display only the person_name and contact_number from the travel_card table whose travel_payment destination route North East line with amount >25.2. Tables involved are travel_card, travel_payment and station3. In travel_payment table, the exit_station_id must match with the station id with name ‘North East line’ and amount greater than 25.4. Order by is mandatory.5. Compare your executed result with the sample output given below.

Write a query to display travel_card_id, entry_time and exit_time from the travel_payment.Display the records in ascending order based on the entry_time.Note:1. Display only the column named travel_card_id, entry_time and exit_time present in the travel_payment table.2. Order by is mandatorySample output: [Only few records are shown here]

1/3

Upgrade your grade with Knowee

Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.