loading..
   English
03:49

Appendix 2. Exercises list page 3

No. DB Level Task Stage T&S
51 A3 3 Find the names of the ships having the largest amount of guns among all the ships with the same displacement (taking into account Outcomes table). Learn +
53 A3 1 To within two decimal digits, define the average amount of guns for the battleship classes. Learn +
54 A3 2 To within two decimal digits, define the average amount of guns for all the battleships (taking into account Outcomes table). Learn +
55 A3 1 For each class, define the year in which the first ship of this class was launched. If year of launch of the head ship is unknown, define the minimum launch year for ships of this class. Result set: class, year. Learn +
56 A3 3 For each class, define the number of ships of this class that were sunk in battles. Result set: class, number of sunked ships. Learn +
57 A3 3 For each class, consisting of at least three ships, define the number of ships (that must be at least 1) of this class sunk in battles. Result set: class, number of sunken ships. Learn +
70 A3 3 Point out the battles in which at least three ships from the same country took part. Learn +
77 A4 2 Find the dates where number of trips from town Rostov were the maximum. Result set: number of trips, date. Learn -
93 A4 2 For each company, find time the company's planes have spent during accomplished flights. Result set: company name, time in minutes. Learn -
11 A4 2 Among the passengers, who flew by the planes of more then one company, find those who made the same number of trips by the planes of each of these companies. Result set: passenger name. Rating -
(-2) A3 2 For each country, find the year, in which the maximal number of ships had been launched. In the case of more than one year in question, take a minimal year. Result set: country, number of ships, year Rating +
17 A3 1 Define the names of all the ships in the database which were definitely launched before 1941. Rating +

Bookmark and Share
Pages 1 2 3
Tags
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.
Rambler's Top100