🙏 We need your help! SQLtest.online has no ads and lives only on donations. Even a small amount helps. Donate now →
SQL code copied to buffer
Task 66:

Clients with Matching First and Last Names

MySQL
Find clients whose first name matches the last name of another client.
Display a table with the fields customer_id, first_name, last_name for the first client and such the same fields customer_id, first_name, last_name for the second. 
Sort by customer_id of the first client.
Expected result Columns: 6 · Rows: 51
customer_id first_name last_name customer_id first_name Last_name

Sample rows open after wrong checks: 0 of 2

Write your query below and click "Check it!". Tables are described in the right pane.

Tutorial

By checking a query, you agree that it is stored without your account details and may be included in anonymized datasets, including for AI training. Learn more

The query result will appear here. Ctrl+Enter - Run query