Celko J. SQL Puzzles and Answers

Second Edition. — Morgan Kaufmann, 2006. — 347 p. — ISBN-10 : 0-12-373596-3, ISBN-13: 978-0-12-373596-3.Contents (Puzzles):
Fiscal Year Tables.
Absentees.
The Anesthesia Puzzle.
Security Badges.
Alpha Data.
Hotel Reservations.
Keeping A Portfolio.
Scheduling Printers.
Available Seats.
Wages Of Sin.
Work Orders.
Claims Status.
Teachers.
Telephone.
Find The Last Two Salaries.
Mechanics.
Employment Agency.
Junk Mail.
Top Salespeople.
Test Results.
Airplanes And Pilots.
Landlord.
Magazine.
One In Ten.
Milestone.
Dataflow Diagrams.
Finding Equal Sets.
Calculate The Sine Function.
Find The Mode Computation.
Average Sales Wait.
Computing Taxes.
Computing Depreciation.
Consultant Billing.
Inventory Adjustments.
Double Duty.
A Moving Average.
Journal Updating.
Insurance Losses.
Permutations.
Budgeting.
Counting Fish.
Graduation.
Pairs Of Styles.
Pepperoni Pizza.
Sales Promotions.
Blocks Of Seats.
Ungrouping.
Widget Count.
Two Of Three.
Budget Versus Actual.
Personnel Problem.
Collapsing A Table By Columns.
Potential Duplicates.
Playing The Ponies.
Hotel Room Numbers.
Gaps—version One.
Gaps—version Two.
Merging Time Periods.
Barcodes.
Sort A String.
Report Formatting.
Contiguous Groupings.
Boxes.
Age Ranges For Products.
Sudoku.
Stable Marriages Problem.
Catching The Next Bus.
Lifo-fifo Inventory.
Buying All The Products.
Stock Trends.
Calculations.
Scheduling Service Calls.
A Little Data Scrubbing.
Derived Tables Or Not?
Finding A Pub.