Appendix 2. Exercises list page 2

No. DB Level Task Stage T&S
23 A1 3 Find the makers producing at least both a pc having speed not less than 750 MHz and a laptop having speed not less than 750 MHz. Result set: Maker Learn +
24 A1 3 Find the model number of the product (PC, laptop, or printer) with the highest price. Result set: model. Learn
25 A1 3 Find the printer makers which also produce PCs with the lowest RAM and the highest-speed processor among PCs with the lowest RAM. Result set: maker. Learn
26 A1 3 Define the average price of the PCs and laptops produced by maker A. Result set: single total price. Learn +
27 A1 3 Define the average size of the PC hard drive for each maker that also produces printers. Result set: maker, average capacity of HD. Learn +
71 A1 1 Find all the PC makers who have all their models of PC type in the PC table. Learn
30 A2 3 Under the assumption that the income (inc) and expenses (out) of the money at each outlet (point) are registered any number of times a day, get a result set with fields: outlet, date, expense, income. Note that a single record must correspond to each outlet at each date. Use Income and Outcome tables. Learn +
59 A2 3 Calculate the remainder at each outlet for the database with accounts drawn not more than once a day. Result set: point, remainder. Learn +
60 A2 1 Calculate the remainder at each outlet prior to 4/15/2001 for the database with accounts for not more than once a day. Result set: point, remainder. Learn +
32 A3 3 One of characteristics of a ship is one-half cube of calibre of its main guns (mw). Within 2 decimal places, define the average value of mw for the ships of each country which has ships in database. Learn
37 A3 2 Find the classes including only one ship in the database (taking into account Outcomes table). Learn +
38 A3 2 Find the countries having classes of both ordinary ships and cruisers. Learn
39 A3 3 Define the ships that "survived for future battles"; being damaged in one battle, they took part in another. Learn +
46 A3 3 Point out the names, displacements and number of guns of ships participating in the battle at Guadalcanal. 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
month ago
©SQL-EX,2008 [Evolution] [Feedback] [About] [Links] [Team]
All right reserved.