Bosses how to use SQL-CodePudding

How to query data
The seventh ninth

CodePudding user response:

You don't have the table structure, had to guesstimate, so roughly:

 select cityName 
The from student 
Where the class in 1501150 (2) 
Group by cityName

 select marjor, count (1) the as CNT 
The from student 
Group by marjor

CodePudding user response:

reference 1/f, gypsy song response:

you don't have the table structure, had to guesstimate, so roughly:

 select cityName 
The from student 
Where the class in 1501150 (2) 
Group by cityName

 select marjor, count (1) the as CNT 
The from student 
Group by marjor

little brother you still know how to do the eleventh? Thank you very much!

CodePudding user response:

reference hope everything to a good start on the second floor response:

Quote: refer to 1st floor gypsy song response:
you don't have the table structure, had to guesstimate, so roughly:

select cityName
The from student
Where the class in 1501150 (2)
Group by cityName

select marjor, count (1) the as CNT
The from student
Group by marjor

little brother you still know how to do the eleventh? Thank you

 select avg (mark) 
The from score