Using Count in SQL database

5 pts.
Tags:
SQL
SQL Database
I have a database with students results, for test and assignments also examination final marks so I want to count the number of student who wrote a certain test, count the number of those who passed and those who failed. How can I implement that in SQL?
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • CharlieBrowne

    This looks like a homework question. We do not do homework at this site. We answer technical business related questions.

    If this is not homework, please post what you have tried, the results you received, and the business reason for your request.

    You are on the right path and need to do more research on COUNT

    62,385 pointsBadges:
    report
  • carlosdl
    You could use a CASE expression in combination with the COUNT aggregate function.

    What have you tried?
    84,835 pointsBadges:
    report
  • ToddN2000
    Sounds like homework. Post the code you have tried and we can help fix what is wrong.
    133,870 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: