Novice answer: average scores greater than 90 points in a lookup table and Chinese classes in the st-CodePudding

As title, table below

CodePudding user response:

Select sno, avg (score) from the name of the table where sno in (select sno from the name of the table where pno='language' and score & gt;=95) group by sno having avg (score) & gt;=90;

CodePudding user response:

The

reference 2 floor F... XX response:

select sno, avg (score) from the name of the table where sno in (select sno from the name of the table where pno='language' and score & gt;=95) group by sno having avg (score) & gt;=90;