Русский    English

Appendix 2. Exercises list page 1

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
Bookmark and Share
Pages 1 2 3
aggregate functions Airport ALL AND AS keyword ASCII AVG Battles Bezhaev Bismarck C.J.Date calculated columns Cartesian product CASE cast CHAR CHARINDEX Chebykin check constraint classes COALESCE common table expressions comparison predicates Computer firm CONSTRAINT CONVERT correlated subqueries COUNT CROSS APPLY CTE data type conversion data types database schema DATEADD DATEDIFF DATENAME DATEPART DATETIME date_time functions DDL DEFAULT DEFAULT VALUES DELETE DISTINCT DML duplicates edge equi-join EXCEPT exercise (-2) More tags
The book was updated
several days ago
©SQL-EX,2008 [Evolution] [Feedback] [About] [Links] [Team]
All right reserved.