Books and articles about SQL Rambler's Top100 Сменить язык на: Русский 18 November 2017 07:18:35


www.sql-ex.ru
Skip Navigation Links  

 

Typical errors at solution of exercises (database "Recycling firm")


AuthorS. Moiseenko

Exercise 47

For each working day (i.e. day when waste was collected), find the #1 in payouts in each pair of inlets having the same numbers in the 2 tables - outcome and outcome_o.
Result set: Inlet #, date, text:
- "once a day", if daily reporting inlet is in the lead;
- "more than once a day", if several times a day reporting inlet is in the lead;
- "both", for draw cases.


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.