SQLgenius

Splash PageEnglish->SQLSQL ExplainerBlogLet SQL Genius write SQL for you(so you can go outside)Check it outMy TablesadmissionsTable NameTable NameRemove TableTable Schemapatient_id INT admission_date DATE discharge_date DATE diagnosis VARCHAR(50) attending_doctor_id INTTable SchemapatientsTable NameTable NameRemove TableTable Schemapatient_id INTEGER first_name VARCHAR(30) last_name VARCHAR(30) gender CHAR(1) birth_date DATE city VARCHAR(30) province_id CHAR(2) allergies VARCHAR(80) height DECIMAL(3, 0) weight DECIMAL(4, 0)Table SchemadoctorsTable NameTable NameRemove TableTable Schemadoctor_id INTEGER first_name VARCHAR(30) last_name VARCHAR(30) specialty VARCHAR(25) Table SchemaAdd New TableAdvanced: SQL TypePostgres SQLAdvanced: SQL TypeMy QuerySql query in EnglishGet the top 5 doctors who have treated the most patients with bee allergiesSql query in EnglishWrite SQLPaste SQL QuerySELECT 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;​Formatted QuerySELECT 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;Explain SQLQuery explained xxxxxxxxxxFeedbackPricingSign Up / Log In --- Splash PageEnglish->SQLSQL ExplainerBlogLet SQL Genius write SQL for you(so you can go outside)Check it outMy TablesadmissionsTable NameTable NameRemove TableTable Schemapatient_id INT admission_date DATE discharge_date DATE diagnosis VARCHAR(50) attending_doctor_id INTTable SchemapatientsTable NameTable NameRemove TableTable Schemapatient_id INTEGER first_name VARCHAR(30) last_name VARCHAR(30) gender CHAR(1) birth_date DATE city VARCHAR(30) province_id CHAR(2) allergies VARCHAR(80) height DECIMAL(3, 0) weight DECIMAL(4, 0)Table SchemadoctorsTable NameTable NameRemove TableTable Schemadoctor_id INTEGER first_name VARCHAR(30) last_name VARCHAR(30) specialty VARCHAR(25) Table SchemaAdd New TableAdvanced: SQL TypePostgres SQLAdvanced: SQL TypeMy QuerySql query in EnglishGet the top 5 doctors who have treated the most patients with bee allergiesSql query in EnglishWrite SQLPaste SQL QuerySELECT 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;​Formatted QuerySELECT 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;Explain SQLQuery explained xxxxxxxxxxHow AI Can Make Learning SQL Easier in 2023SQL Query: Get a Table's Schema in Postgres SQLFirst 5 Things to Learn About SQL in 2023FeedbackPricingSign Up / Log In --- Splash PageEnglish->SQLSQL ExplainerBlogLet SQL Genius write SQL for you(so you can go outside)Check it outMy TablesadmissionsTable NameTable NameRemove TableTable Schemapatient_id INT admission_date DATE discharge_date DATE diagnosis VARCHAR(50) attending_doctor_id INTTable SchemapatientsTable NameTable NameRemove TableTable Schemapatient_id INTEGER first_name VARCHAR(30) last_name VARCHAR(30) gender CHAR(1) birth_date DATE city VARCHAR(30) province_id CHAR(2) allergies VARCHAR(80) height DECIMAL(3, 0) weight DECIMAL(4, 0)Table SchemadoctorsTable NameTable NameRemove TableTable Schemadoctor_id INTEGER first_name VARCHAR(30) last_name VARCHAR(30) specialty VARCHAR(25) Table SchemaAdd New TableAdvanced: SQL TypePostgres SQLAdvanced: SQL TypeMy QuerySql query in EnglishGet the top 5 doctors who have treated the most patients with bee allergiesSql query in EnglishWrite SQLPaste SQL QuerySELECT 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;​Formatted QuerySELECT 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;Explain SQLQuery explained xxxxxxxxxx ​How AI Can Make Learning SQL Easier in 2023SQL Query: Get a Table's Schema in Postgres SQLFirst 5 Things to Learn About SQL in 2023FeedbackPricingSign Up / Log In --- Splash PageEnglish->SQLSQL ExplainerBlogLet SQL Genius write SQL for you(so you can go outside)Check it outMy TablesadmissionsTable NameTable NameRemove TableTable Schemapatient_id INT admission_date DATE discharge_date DATE diagnosis VARCHAR(50) attending_doctor_id INTTable SchemapatientsTable NameTable NameRemove TableTable Schemapatient_id INTEGER first_name VARCHAR(30) last_name VARCHAR(30) gender CHAR(1) birth_date DATE city VARCHAR(30) province_id CHAR(2) allergies VARCHAR(80) height DECIMAL(3, 0) weight DECIMAL(4, 0)Table SchemadoctorsTable NameTable NameRemove TableTable Schemadoctor_id INTEGER first_name VARCHAR(30) last_name VARCHAR(30) specialty VARCHAR(25) Table SchemaAdd New TableAdvanced: SQL TypePostgres SQLAdvanced: SQL TypeMy QuerySql query in EnglishGet the top 5 doctors who have treated the most patients with bee allergiesSql query in EnglishWrite SQLPaste SQL QuerySELECT 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;​Formatted QuerySELECT 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;Explain SQLQuery explained xxxxxxxxxxHow AI Can Make Learning SQL Easier in 2023SQL Query: Get a Table's Schema in Postgres SQLFirst 5 Things to Learn About SQL in 2023FeedbackPricingSign Up / Log In