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.

select device_id mingpauniversityfrom user_profilewhere universitygpain select universitymingpafrom user_profile group by universitygroup by university

原文地址: https://www.cveoy.top/t/topic/jfWK 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录