Poizvedbe v živo

SQL laboratorij

Izberite primer, preberite SQL in takoj primerjajte rezultat.

Nazaj k modelu baze
FIREBIRD SQLizvedeno ob odprtju
SELECT FIRST 8 F.TITLE, H.NAME AS HALL, SC.START_TIME, SC.BASE_PRICE
            FROM SCREENING SC
            JOIN FILM F ON F.FILM_ID = SC.FILM_ID
            JOIN HALL H ON H.HALL_ID = SC.HALL_ID
            ORDER BY SC.START_TIME
titlehallstart timebase price
Mesto pod zvezdamiDvorana Orion2026-11-06 18:00:008.50
Zadnji tramvajStudio Luna2026-11-06 20:30:007.00
Sava: 990 kilometrov zgodbStudio Luna2026-11-07 17:00:006.50
Signal iz TriglavaDvorana Orion2026-11-07 19:00:009.50
Hotel OrionStudio Luna2026-11-08 19:00:008.50
Arhiv tišineDvorana Orion2026-11-08 20:30:008.00
Mesto pod zvezdamiDvorana Orion2026-11-10 18:00:008.50
Signal iz TriglavaDvorana Orion2026-11-11 21:00:009.50