Famous Universities starting with the letter "L"

USA


		ROM

Error at line: 1055 : Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'famousw_famousdata.celebrity.c_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SqlSELECT c_id FROM celebrity WHERE c_university LIKE 'L%' GROUP BY c_university