Jump to content

SQL. SELECT AND COUNT


ingerNorway

Recommended Posts

Hi! 
I can't figure out this code: 
 

SELECT Student.fornavn,etternavn,brukernavn Fag.fagkode,
COUNT(Oppgave.nr) AS AntalOppgaver 
FROM Student,Fag
LEFT JOIN Student
WHERE Fag.fagkode='DAT1000'
            = Syntax error , mariadb.......

The task text is : 
The question should get an overview of all students(Here: Student) in a choosen subject(Here:fag) and count how many tasks(here:oppgave) 
The overview should show sirname(Etternavn)name(Fornavn) username(Brukernavn)and numbers of tasks in the subject(fag)
The overview shuld be order by sirname(etternavn)and then on name(fornavn)

Any idea? 

- Look at the E/R attachment :)post-165326-0-83988300-1383042460_thumb.gif

Link to comment
https://forums.phpfreaks.com/topic/283396-sql-select-and-count/
Share on other sites

THIS SHOULD BE THE RIGHT CODE but it won't work: 

SELECT etternavn,fornavn,Student.brukernavn,
COUNT(nr) AS AntallOppgaver 
FROM Student
INNER JOIN (Fagdeltager INNER JOIN Oppgave ON Fagdeltager.fagkode=Oppgave.fagkode) ON
Student.brukernavn=Fagdeltager.brukernavn)
WHERE Fagdeltager.fagkode='DAT1000'
GROUP BY etternavn,fornavn;

THIS SHOULD BE THE RIGHT CODE but it won't work: 


SELECT etternavn,fornavn,Student.brukernavn,

COUNT(nr) AS AntallOppgaver 

FROM Student

INNER JOIN (Fagdeltager INNER JOIN Oppgave ON Fagdeltager.fagkode=Oppgave.fagkode) ON

Student.brukernavn=Fagdeltager.brukernavn

WHERE Fagdeltager.fagkode='DAT1000'

GROUP BY etternavn,fornavn;

try it without the nested join

SELECT etternavn,fornavn,Student.brukernavn,
COUNT(nr) AS AntallOppgaver 
FROM Student
INNER JOIN Fagdeltager ON Student.brukernavn=Fagdeltager.brukernavn
INNER JOIN Oppgave ON Fagdeltager.fagkode=Oppgave.fagkode
WHERE Fagdeltager.fagkode='DAT1000'
GROUP BY etternavn,fornavn;

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.