Books and articles about SQL Rambler's Top100 Сменить язык на: Русский 19 March 2024 09:39:33


www.sql-ex.ru
Skip Navigation Links  

 

Typical errors at solution of exercises (database "Aeroflot")


AuthorS. Moiseenko

Exercise 33

Find the dates where number of trips from town Rostov were the maximum. Result set: number of trips, date.

AuthorS. Moiseenko

Exercise 40

Find the names of all companies, each possessing a superset of all plane types that some other company also possesses.

AuthorS. Moiseenko

Exercise 49

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.


Usage of any materials of this site is possible
only under condition of mandatory allocation of the direct link to a site
http://www.sqlbooks.ru
on each page where used materials are placed.

 Main   Articles    Books 
Рейтинг@Mail.ru Rambler's Top100 Alt Упражнения по SQL: обучение, тестирование, сертификация по языку SQL Copyright c 2002-2006. All rights reserved.