github-actions[bot] commented on issue #13579: URL: https://github.com/apache/dolphinscheduler/issues/13579#issuecomment-1434371686
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and found no similar feature requirement. ### Description ```sql drop table if exists `user_profile`; drop table if exists `question_practice_detail`; drop table if exists `question_detail`; CREATE TABLE `user_profile` ( `id` int NOT NULL, `device_id` int NOT NULL, `gender` varchar(14) NOT NULL, `age` int , `university` varchar(32) NOT NULL, `gpa` float, `active_days_within_30` int , `question_cnt` int , `answer_cnt` int ); CREATE TABLE `question_practice_detail` ( `id` int NOT NULL, `device_id` int NOT NULL, `question_id`int NOT NULL, `result` varchar(32) NOT NULL ); CREATE TABLE `question_detail` ( `id` int NOT NULL, `question_id`int NOT NULL, `difficult_level` varchar(32) NOT NULL ); INSERT INTO user_profile VALUES(1,2138,'male',21,'School 1',3.4,7,2,12); INSERT INTO user_profile VALUES(2,3214,'male',null,'School 2',4.0,15,5,25); INSERT INTO user_profile VALUES(3,6543,'female',20,'School 3',3.2,12,3,30); INSERT INTO user_profile VALUES(4,2315,'female',23,'School 4',3.6,5,1,2); INSERT INTO user_profile VALUES(5,5432,'male',25,'School 5',3.8,20,15,70); INSERT INTO user_profile VALUES(6,2131,'male',28,'School 6',3.3,15,7,13); INSERT INTO user_profile VALUES(7,4321,'male',28,'School 7',3.6,9,6,52); INSERT INTO question_practice_detail VALUES(1,2138,111,'wrong'); INSERT INTO question_practice_detail VALUES(2,3214,112,'wrong'); INSERT INTO question_practice_detail VALUES(3,3214,113,'wrong'); INSERT INTO question_practice_detail VALUES(4,6543,111,'right'); INSERT INTO question_practice_detail VALUES(5,2315,115,'right'); INSERT INTO question_practice_detail VALUES(6,2315,116,'right'); INSERT INTO question_practice_detail VALUES(7,2315,117,'wrong'); INSERT INTO question_practice_detail VALUES(8,5432,117,'wrong'); INSERT INTO question_practice_detail VALUES(9,5432,112,'wrong'); INSERT INTO question_practice_detail VALUES(10,2131,113,'right'); INSERT INTO question_practice_detail VALUES(11,5432,113,'wrong'); INSERT INTO question_practice_detail VALUES(12,2315,115,'right'); INSERT INTO question_practice_detail VALUES(13,2315,116,'right'); INSERT INTO question_practice_detail VALUES(14,2315,117,'wrong'); INSERT INTO question_practice_detail VALUES(15,5432,117,'wrong'); INSERT INTO question_practice_detail VALUES(16,5432,112,'wrong'); INSERT INTO question_practice_detail VALUES(17,2131,113,'right'); INSERT INTO question_practice_detail VALUES(18,5432,113,'wrong'); INSERT INTO question_practice_detail VALUES(19,2315,117,'wrong'); INSERT INTO question_practice_detail VALUES(20,5432,117,'wrong'); INSERT INTO question_practice_detail VALUES(21,5432,112,'wrong'); INSERT INTO question_practice_detail VALUES(22,2131,113,'right'); INSERT INTO question_practice_detail VALUES(23,5432,113,'wrong'); INSERT INTO question_detail VALUES(1,111,'hard'); INSERT INTO question_detail VALUES(2,112,'medium'); INSERT INTO question_detail VALUES(3,113,'easy'); INSERT INTO question_detail VALUES(4,115,'easy'); INSERT INTO question_detail VALUES(5,116,'medium'); INSERT INTO question_detail VALUES(6,117,'easy'); SELECT distinct up.device_id,up.gender,up.age,up.gpa,up.university FROM user_profile up LEFT JOIN question_practice_detail qd ON up.device_id= qd.device_id WHERE up.university = "山东大学" OR up.gender = "male" ORDER BY up.university desc,up.gender desc; select device_id , gender , age , gpa from user_profile where university = '山东大学' UNION ALL select device_id , gender , age , gpa from user_profile where gender = 'male'; ``` ### Use case _No response_ ### Related issues _No response_ ### Are you willing to submit a PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
