New game
Download
SCORM download
To be used in an LMS (Moodle, Blackboard...)
Regular download
To be published on a website or blog.
Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.
Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.
Get Academic Plan
If you wish, you can download a demo game here and test its integration:
Share game
Fill in the Blanks
Fill in the Blanks

adatb

Integrate it into your platform
G. Classroom M. Teams
You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.
Download
You have exceeded the maximum number of games you can integrate into Google Classroom with your current Plan.

To integrate as many games as you want in Google Classroom, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
You have exceeded the maximum number of games you can integrate into Microsoft Teams with your current Plan.

To integrate as many games as you want in Microsoft Teams, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.

Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.

If you wish, you can download a demo game here and test its integration:

Get Academic Plan
%
Anonymous
Anonymous
 %
%
%
You have exceeded the maximum number of games you can print with your current Plan.

To print as many games as you want, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
Print your game
adatb
 

Fill in the Blanks

adatbOnline version

adatb

by Dominik Ádám
1

jegyeladasok Extract ( Year from Eladasok . datum ) AS ev , EXTRACT ( MONTH from Eladasok . datum ) AS honap , , SUM ( ) 'Kecskemét' FROM Eladasok JOIN Jegy ON Eladasok . datum = Jegy . datum AND Eladasok . hely = Jegy . hely AND Eladasok . terem = Jegy . terem GROUP BY ev , honap ;

2

Vonatjegyek , ( . ) FROM JOIN ON UlesSzama . jaratazonosito = Vonatjegy2 . jaratazonosito AND UlesOsztaly . ulesSzama = Vonatjegy2 . ulesSzama GROUP BY kocsiosztál y

3

Vonatjegyek SELECT , , ( * ) FROM Vonatjegy1 BY ( ) ;

4

INSERT EladottKonyvek EXTRAFT ( YEAR FROM Eladasok . idopont ) AS ev , EXTRACT ( MONTH FROM Eladasok . idopont ) AS honap , Eladasok . isbn , ( ) , ( * ) 'Bolt2' FROM Konyvek JOIN Eladasok ON Eladasok . isbn = konyvek . isbn GROUP BY isbn , ev , hona p

5

SELECT ( Jegyeladas , ( , ) ) AS result FROM Jegyeladasok j ;

6

SELECT ( Vonat , ( , ) ) AS result FROM Vonatok v ;

7

SELECT ( Vonat , ( ) AS jaratazonosito ) , ( , ) , ( , ) AS result FROM Vonatok v ;

8

SET SERVEROUTOUT ON
DECLARE
v_jaratazonosito Vonatok . jaratazonosito%TYPE
FUNCTION helyszamtotCsokkent ( p_jaratazonosito NUMBER , p_foglal NUMBER )
IS
v_helyekSzama NUMBER
BEGIN
SELECT szabadhelyekSzama INTO v_helyekSzama FROM Vonatok WHERE jaratazonosito = p_jaratazonosito ;
IF v_helyekSzama > = p_foglal THEN
UPDATE Vonatok SET szabadHelyekSzama = szabadHelyekSzama - foglal
WHERE jaratazonosito = p_jaratazonosito ;
RETURN TRUE ;
END IF ;
RETURN FALSE ;
EXCEPTION
WHEN THEN
DBMS_OUTPUT . PUT_LINE ( 'Nincs ilyen feltételenek megfelel ? rekord' ) ;
WHEN THEN
DBMS_OUTPUT . PUT_LINE ( 'Több rekordot adott vissza a lekérdezés' ) ;
WHEN OTHERS THEN
DBMS_OUTPUT . PUT_LINE ( 'Egyéb hiba történt' ) ;
END ;

9

SET SERVEROUTPUT ON
DECLARE
TYPE gyujtotipus IS TABLE OF ;
gyujto gyujtotipus ;
CURSOR kurzus IS SELCET jaratazonosito , COUNT ( * ) AS darab FROM Menetjegyek GROUP BY jaratazonosito ;
idx BINARY_INTEGER
BEGIN
OPNE kurzor
idx : = 1 ;
FOR rekord IN kurzor
LOOP
gyujto ( idx ) : = rekord . darab
idx : = idx + 1 ;
END LOOP

- - kiíratjuk a gy ? jt ? tábla elemeit
idx : =
LOOP
WHEN idx : =
DBMS_OUTPUT . PUT_LINE { idx | | ' : ' | | gyujto ( idx ) } ;
idx : = gyujto . { idx } ;
END LOOP
CLOSE kurzor
END ;

10

SET SERVEROUTOUT ON
DECLARE
v_havi_eladasok NUMBER ;
haviEladasok ( p_honap NUMBER )
IS
v_darabszam NUMBER ;
v_jegytipus jegyeladasok . jegytipus%TYPE ;
BEGIN
SELECT jegytipus , SUM ( ar ) INTO v_jegytipus , v_darabszam
FROM jegyeladasok WHERE honap = p_honap GROUP BY jegytipus
DBMS_OUTPUT . PUT_LINE ( p_honap | | 'hónapban' jegytipus | | ' - ' | | v_darabszam ) ;
v_darabszam ;
EXCEPTION
WHEN THEN

11

SET SERVEROUPUT ON
DECLARE
TYPE rekordTipus IS RECORD ( isbn Konyvek . isbn%TYPE , cím Konyvek . cim%TYPE , ar Konyvek . ar%TYPE , darabszam NUMBER ) ;
TYPE gyujtotipus IS TABLE OF rekord Tipus INDEX BY BINARY_INTEGER ;
gyujto gyutjotipus
CURSOR kurzor IS SELECT isbn , cim , ar COUNT ( * ) AS darabszam FROM Konyvek GROUP BY isbn ;
idx BINARY_INTEGER
BEGIN
OPEN kurzor
idx : = 1 ;

FETCH kurzor INTO gyujto ( idx )
EXIT WHEN
idx : = idx + 1 ;
LOOP
ClOSE kurzor
EN D

12

kedvezmenyesAR ( p_isbn VARCHAR2 , p_kedvezmeny NUMBER ) RETURN NUMBER IS
v_ar Konyvek . ar%TYPE
e_rosszErtek EXCEPTION
BEGIN
IF p_kedvezmeny < 0 p_kedvezmeny > 100 THEN
RAISE e_rosszErtek ;
END IF
EXCEPTION
WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT . PUT_LINE ( 'Nincs ilyen feltételnek megfelel ? rekord' )
END kedvezmenyesA r

13

SELECT ( jegyeladas , ( , ) ) AS result FROM jegyeladasok j ;

14

SELECT ( Vonat , ( , ) ) AS result FROM Vonatok v ;

 
Are you sure you want to leave the page?

If you leave, you will lose the game in progress.