Write an SQL query on the table STUDENT that for each class lists ...

[abern]

Write an SQL query on the table STUDENT that for each class lists the class and the number of students in the class.
 
  What will be an ideal response?

Question 2

If A, B, C, and D are columns of the table whose composite primary key is A, Bwhile C and D are nonkey columnsthen B --> D is a transitive functional dependency.
 
  Indicate whether the statement is true or false

[Chou]

Answer to Question 1

SELECT class, COUNT()
FROM student
GROUP BY class;

Answer to Question 2

FALSE

[abern]

Thanks for the timely response, appreciate it

[vickyvicksss]

Wow, this really help