Member Avatar for vedro-compota

Hi guys!
Please - tell me -how to perform the following task.

There is a table-

table SUBJECT
(
  SUBJ_ID   NUMERIC not null,
  SUBJ_NAME VARCHAR(100),
  HOUR      NUMERIC,
  SEMESTER   NUMERIC
);

I need to count the number of items. studied in each course.
I had already counted number of subjects, studied in each semester -

SELECT SEMESTER , COUNT(*) FROM SUBJECT GROUP BY SEMESTER;

but is it possible to count for each course?

Thanks in advance!))

Edited by vedro-compota because: n/a
  • 2 Contributors
  • 1 Reply
  • 62 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by smantscheff
Member Avatar for smantscheff

What's an "item", what is a "course" in your database?

commented: + +1
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.