Here is the SQL query you need:

```sql
SELECT person_name, contact_number
FROM travel_card
ORDER BY person_name ASC;
```

This query does the following:

1. `SELECT person_name, contact_number`: This part selects the columns `person_name` and `contact_number` from the database.

2. `FROM travel_card`: This part specifies the table `travel_card` from which to retrieve the data.

3. `ORDER BY person_name ASC`: This part sorts the result in ascending order (`ASC`) by the `person_name` column.

Question

Here is the SQL query you need:

```sql
SELECT person_name, contact_number 
FROM travel_card 
ORDER BY person_name ASC;
```

This query does the following:

1. `SELECT person_name, contact_number`: This part selects the columns `person_name` and `contact_number` from the database.

2. `FROM travel_card`: This part specifies the table `travel_card` from which to retrieve the data.

3. `ORDER BY person_name ASC`: This part sorts the result in ascending order (`ASC`) by the `person_name` column.

Knowee AI · Accepted Answer

Here is the SQL query you need:

```sql
SELECT person_name, contact_number 
FROM travel_card 
ORDER BY person_name ASC;
```

This query does the following:

1. `SELECT person_name, contact_number`: This part selects the columns `person_name` and `contact_number` from the database.

2. `FROM travel_card`: This part specifies the table `travel_card` from which to retrieve the data.

3. `ORDER BY person_name ASC`: This part sorts the result in ascending order (`ASC`) by the `person_name` column.

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 mandatory