SELECT RNr AS Raumnummer, IP FROM Installation INNER JOIN PC ON Installation.SwID = Software.SwID WHERE Software.Beschreibung = 'putty' AND Version = '0.73' ORDER BY RNr ASC, IP ASC;
1.1.2 SQL
SELECT RNr AS Raumnummer, COUNT(*) AS Anzahl
FROM PC
GROUP BY RNr;
1.1.13 SQL
INSERT INTO PC (MAC, IP, RNr, Beschreibung)
VALUES ('9C:5C:8E:76:66:3F','10.0.0.3','201','i5-8GB-250GB');