Here you find a possible drag$-$and$-$drop question with databases.

The following structure for a relational database is given. It contains the members of an association and the available uniforms.

Please note that the given datatypes are SQLite datatypes. PK and FK stand for primary key and foreign key respectively.

Members

Code $($PK$)$ integer

FirstName text

LastName text

Uniforms

Code $($PK$)$ integer

Size integer

ColorNumber integer

ProductionDate text

Member $($FK$)$ integer

Your task is:

Select all uniforms whose size is smaller than $40$ and whose color number is equal to $3.$

The request is done with:

SELECT Blank $1$ Question $15$ FROM Blank $2$ Question $15$ WHERE Blank $3$ Question $15$