找到分数> gt的学生姓名的mysql查询是什么?过去5年60?

问题描述:

MySQL查询将查找具有分数>的学生的姓名。 60年过去5年?



表格结构:

student_name varchar(20) ,

得分int(5),

年份(4)



PHP版本5.6 .36



我尝试过:



尝试google但没有帮助。

What will be the MySQL query to find the name of students having a score > 60 for the last 5 years?

Table structure :
student_name varchar(20),
score int (5),
year Year(4)

PHP Version 5.6.36

What I have tried:

Tried to google it but didn't help.

你需要正确学习SQL

SQL教程 [ ^ ]



所以,你没有尝试自己解决问题,你毫无疑问,你只是想让我们做你的HomeWork。

HomeWork问题是你在现实生活中必须解决的问题的简化版本,他们的目的是学习和练习



我们不做你的HomeWork。

HomeWork不会测试你乞求别人做你的工作的技巧,它是让您思考并帮助您的老师检查您对所学课程的理解以及您应用这些课程时遇到的问题。

你的任何失败都会帮助你的老师发现你的弱点并设定补救措施。

你的任何失败都会帮助你了解什么有效,什么无效,被称为'试错'学习。

所以,试一试,重读课程并开始工作。如果您遇到特定问题,请展示您的代码并解释这个问题,我们可能会提供帮助。
You need to learn properly SQL
SQL Tutorial[^]

So, you show no attempt to solve the problem yourself, you have no question, you just want us to do your HomeWork.
HomeWork problems are simplified versions of the kind of problems you will have to solve in real life, their purpose is learning and practicing.

We do not do your HomeWork.
HomeWork is not set to test your skills at begging other people to do your work, it is set to make you think and to help your teacher to check your understanding of the courses you have taken and also the problems you have at applying them.
Any failure of you will help your teacher spot your weaknesses and set remedial actions.
Any failure of you will help you to learn what works and what don't, it is called 'trial and error' learning.
So, give it a try, reread your lessons and start working. If you are stuck on a specific problem, show your code and explain this exact problem, we might help.