SQL LESSON 131 - GROUP BY - COUNT

Опубликовано: 19 Октябрь 2024
на канале: MS / Access

182

englishspacedog YouTube tutorial from Canada
http://www.herostratus.ca/PC.htm

Here's the SQL code:

SELECT tblGALAXIES.GalaxyID,
COUNT(StarID) AS NumberOfStars
FROM tblSTARS
JOIN tblGALAXIES
ON tblSTARS.GalaxyID = tblGALAXIES.GalaxyID
GROUP BY tblGALAXIES.GalaxyID

SELECT tblGALAXIES.GalaxyID,
StarID
FROM tblSTARS
JOIN tblGALAXIES
ON tblSTARS.GalaxyID = tblGALAXIES.GalaxyID
ORDER BY tblGALAXIES.GalaxyID, tblSTARS.StarID