A. 对 B. 错
A. SELECT CNO FROM SC WHERE COUNT(*)<4 B. SELECT CNO FROM SC GROUP BY CNO HAVING COUNT(*)<4 C. SELECT DISTINCT CNO FROM SC ORDER BY CNO D. SELECT CNO FROM SC WHERE COUNT(CNO)<4