Query the table TBL middle school student's name and more than 80 points of course gate number-CodePudding

Home > database > Query the table TBL middle school student's name and more than 80 points of course gate number

Query the table TBL middle school student's name and more than 80 points of course gate number

Time：09-21

Query the table TBL middle school student's name and course gate number greater than 80 points

CodePudding user response:

Select the name, the count () from the table name where the score & gt; 80;
This is the meaning of code