1. Anton Golov
  2. Database Assignment

Commits

Anton Golov  committed 88e6c39

Got 7 to work.

  • Participants
  • Parent commits 4407480
  • Branches default

Comments (0)

Files changed (1)

File queries.txt

View file
  • Ignore whitespace
 
 SELECT RaceName, ClassName
 FROM Character
-NATURAL JOIN IsOfClass, Class, Race
+NATURAL JOIN IsOfClass
+NATURAL JOIN Class
+NATURAL JOIN Race
 GROUP BY Character.RaceId, IsOfClass.ClassId
 HAVING COUNT(*) == (
     SELECT MAX(temp.v)