( 설마 숙제는 아니겠죠? ^^ )

별로 복잡하지는 않습니다만, 애초에 이렇게 설계된 것이 잘못된 거 아닐까 생각됩니다.

예제데이터)

mysql> SELECT * FROM rc;
+------+------+------+------+------+
| c1   | c2   | c3   | c4   | c5   |
+------+------+------+------+------+
|    1 |    2 |    3 |    4 |    5 |
|    6 |    7 |    8 |    9 |   10 |
|   11 |   12 |   13 |   14 |   15 |
+------+------+------+------+------+
3 rows in set (0.00 sec)

1)
mysql> SELECT L, 5-L AS GE FROM ( SELECT IF(c1>=8,0,1)+IF(c2>=8,0,1)+IF(c3>=8,0,1)+IF(c4>=8,0,1)+IF(c5>=8,0,1) AS L FROM rc) x;

+---+----+
| L | GE |
+---+----+
| 5 |  0 |
| 2 |  3 |
| 0 |  5 |
+---+----+
3 rows in set (0.00 sec)

2)
mysql> SELECT c1 AS c FROM ( SELECT c1 FROM rc UNION SELECT c2 FROM rc UNION SELECT c3  FROM  rc UNION SELECT c4  FROM  rc UNION SELECT c5  FROM  rc ) t ORDER BY c1;

+------+
| c    |
+------+
|    1 |
|    2 |
|    3 |
|    4 |
|    5 |
|    6 |
|    7 |
|    8 |
|    9 |
|   10 |
|   11 |
|   12 |
|   13 |
|   14 |
|   15 |
+------+
15 rows in set (0.00 sec)

개념이 없다보니  헤메고 있었는데..  아~ 이런 방법이 있었군요..
친절한 답변 감사합니다. ㅎㅎ  꾸벅(__)(---)