Names of all people Display the names of all people in the airline database Fields in the resulting table: name

To list the names of all people in an airline database, you need to execute an SQL query that selects the name field from the table where person data is stored (for example, people or passengers). An example query:

SELECT name FROM people;

If there are multiple tables with people in the database, you need to specify which one. To remove duplicates, you can use DISTINCT:

SELECT DISTINCT name FROM people;