T

tolsor2018-05-07 01:08:46

MySQL

tolsor, 2018-05-07 01:08:46

How to write a sql query to find out the percentage?

How to calculate the percentage of twos given by each teacher?

Table Schema:

I can not:

SELECT `kod_prepod` AS 'Код преподавателя', COUNT(`ocenka`=2) * 100 / COUNT(`ocenka`) AS 'Процент двоек' FROM `uspev`

Reply

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

A

Anholle2019-09-09 11:37:42

J

Julia2017-06-07 21:43:07

H

hbrmdc2015-07-11 07:09:45

U

Udee Mo2021-05-16 14:36:06

S

synapse_people2021-05-17 11:49:28

Didn't find what you were looking for?