MySQL基础练习题49-低质量的问题

目录

题目

准备数据

分析数据

总结

---

题目

找出 低质量 问题的 ID 集合。如果一个力扣问题的喜欢率（喜欢数除以总投票数）严格低于 60% ，则该问题为低质量问题。

按 problem_id 升序排列返回结果表。

准备数据

Create table If Not Exists Problems (problem_id int, likes int, dislikes int)
    Truncate table Problems
    insert into Problems (problem_id, likes, dislikes) values ('6', '1290', '425')
    insert into Problems (problem_id, likes, dislikes) values ('11', '2677', '8659')
    insert into Problems (problem_id, likes, dislikes) values ('1', '4446', '2760')
    insert into Problems (problem_id, likes, dislikes) values ('7', '8569', '6086')
    insert into Problems (problem_id, likes, dislikes) values ('13', '2050', '4164')
    insert into Problems (problem_id, likes, dislikes) values ('10', '9002', '7446')

分析数据

select
    problem_id
    from problems
where (likes / (likes + dislikes)) < 0.6
order by problem_id;

 

总结

排序使用的函数是 order by