select device_id mingpauniversityfrom user_profilewhere universitygpain select universitymingpafrom user_profile group by universitygroup by university
The query selects the device_id, minimum gpa, and university from the user_profile table. It filters the results to only include rows where the combination of university and gpa is present in the subquery. The subquery selects the minimum gpa for each university from the user_profile table. Finally, the results are grouped by university.
原文地址: https://www.cveoy.top/t/topic/jfWK 著作权归作者所有。请勿转载和采集!