Only the exercises considered in the book are listed here. On a site SQL-EX.RU, besides them, there are many other exercises, and new ones are being added on a regular basis.
| No.
|
DB
|
Level
|
Task
|
Stage
|
T&S
|
| 1 | A1 | 1 | Find the model number, speed and hard drive capacity for all the PCs with prices below 0. Result set: model, speed, hd. | Learn | |
| 2 | A1 | 1 | Find printer makers. Result set: maker. | Learn | + |
| 3 | A1 | 1 | Find the model number, RAM and screen size of the laptops with prices over 00. | Learn | |
| 5 | A1 | 1 | Find the model number, speed and hard drive capacity of the PCs having 12x CD and prices less than 0 or having 24x CD and prices less than 0. | Learn | |
| 6 | A1 | 2 | Point out the maker and speed of the laptops having hard drive capacity more or equal to 10 Gb. | Learn | + |
| 7 | A1 | 2 | Find out the models and prices for all the products (of any type) produced by maker B. | Learn | + |
| 8 | A1 | 2 | Find out the makers that sale PCs but not laptops. | Learn | + |
| 10 | A1 | 1 | Find the printers having the highest price. Result set: model, price. | Learn | + |
| 11 | A1 | 1 | Find out the average speed of PCs. | Learn | + |
| 13 | A1 | 1 | Find out the average speed of the PCs produced by maker A. | Learn | |
| 15 | A1 | 2 | Find the hard drive sizes that are equal among two or more PCs. Result set: hd. | Learn | + |
| 16 | A1 | 2 | Find the pairs of PC models having similar speeds and RAM. As a result, each resulting pair is shown only once, i.e. (i, j) but not (j, i). Result set: model with higher number, model with lower number, speed, and RAM. | Learn | + |
| 17 | A1 | 2 | Find the laptop models having speeds less than all PCs. Result set: type, model, speed. | Learn | + |
| 18 | A1 | 2 | Find the makers of the cheapest color printers. Result set: maker, price. | Learn | + |
| 20 | A1 | 2 | Find the makers producing at least three distinct models of PCs. Result set: maker, number of models. | Learn | |
|
go
