- SELECT bolt_nev, bolt_ID, boltok.varos FROM boltok INNER JOIN vasarlasok ON fk_boltID = bolt_ID INNER JOIN torzsvasarlok ON fk_kartyaszam = kartyaszam WHERE torzsvasarlok.varos = "Budapest" AND boltok.varos = "Budapest" ORDER BY bolt_nev;
- SELECT nev, varos, utca_hazszam, irsz FROM torzsvasarlok LEFT JOIN vasarlasok ON fk_kartyaszam = kartyaszam WHERE vasarlas_ID IS NULL;
- SELECT COUNT(nev) AS "szamlalas", varos FROM torzsvasarlok WHERE nev LIKE "%a" GROUP BY varos ORDER BY szamlalas;
- SELECT nev, varos, utca_hazszam, irsz FROM torzsvasarlok GROUP BY varos;
- CREATE TABLE akciok ( akc_ID INT AUTO_INCREMENT PRIMARY KEY, akc_nev VARCHAR(20), akc_szazalek INT NOT NULL, kezdo_datum TIMESTAMP)
- ALTER TABLE torzsvasarlok ADD COLUMN vevo_min INT;
- DELETE torzsvasarlok FROM torzsvasarlok LEFT JOIN vasarlasok ON kartyaszam = fk_kartyaszam WHERE vasarlasok_ID IS NULL AND varos = "Budapest";