Database - Practice

WORDS

database vocab

Játék

https://learningapps.org/2120308

When solving the following exercises, save the queries with the name given 
in brackets. Pay attention to displaying exactly the required fields in the queries, do not display 
unnecessary fields. 

ANIMAL NAMES

2. Create a query that lists the titles and the years of publishing of István Fekete’s novels 
published between 1950 and 1990 in alphabetical order according to title. The given period 
also includes the limits (2titles) 

solution:

3. Create a query that lists the animal names where the name of the species contains the word 
part “wild”. The list should include the name of the animal and the name of the species. 
(3wild)

4. Animals belonging to different species appear in different numbers among the names given 
by István Fekete. Create a query that determines the number of animal names per species. 
The list should contain the name of the species and the number of names in descending 
order according to the latter. (4distribution) 
5. Create a query that lists the animal names that appear in several novels. (5popular)

BORDER CROSSING POINTS

2. Create a query that lists the names of the Hungarian and Serbian settlements of the road 
border crossing points that lead to Serbia ordered according to the former settlements. 
(2toserbia) 
3. Using a query, give the names of the villages with a border crossing point. Display the 
name of each village only once in the result. (3village) 
4. Using a query, determine the number of rail border crossing points to each of the 
neighbouring countries. Display the results in decreasing order according to the number of 
crossing points. (4rail)

5. Using a query, give the number of border crossing points for each county in the database. 
In the result display only the names of the counties that have border crossing points and 
the number of border crossing points in decreasing order according to the latter. 
(5counties)