cars Lösungen

SELECT COUNT(id) FROM cars;

100

INSERT INTO cars
  (brand, color, year)
VALUES
  ('VW', 'blue', 2009);

SELECT COUNT(id), color
FROM cars
WHERE year > 2020
GROUP BY color;

2010

DELETE FROM cars
WHERE name = '%dd%';

SELECT * FROM cars
ORDER BY brand, hp;

UPDATE cars
SET color = 'yellow'
WHERE code_name = 'Fanionter';

80, 2005
255, 2010

SELECT * FROM cars
WHERE year = 2001;