Let SQL Genius write SQL for you

(so you can go outside)

My Tables

admissions

Table Name

Table Schema

patients

Table Name

Table Schema

doctors

Table Name

Table Schema

Advanced: SQL Type

My Query

Sql query in English

Paste SQL Query

Formatted Query

SELECT CONCAT(first_name, ' ', last_name) AS full_name,
LENGTH(CONCAT(first_name, ' ', last_name)) AS name_length
FROM patients
ORDER BY name_length DESC
LIMIT 1;

Query explained

xxxxxxxxxx