This book takes as a starting point, John Dewey's article, "The Reflex Arc Concept in Psychology," in which Dewey was calling for, in short, the utilisation of systems theories within psychology, theories of behaviour that capture its nature as a vastly-complex dynamic coordination of nested coordinations. This line of research was neglected as American psychology migrated towards behaviourism, where perception came to be thought of as being both a neural response to an external stimulus and a mediating neural stimulus leading to, or causing a muscular response. As such, perception becomes a question of how it is the perceiver creates neural representations of the physical world. Gestalt psychology, on the other hand, focused on perception itself, utilising the term Phenomenological Field; a term that elegantly nests perception and the organism within their respective, as well as relative, levels of organisation. With the development of servo-mechanisms during the second world war, systems theory began to take on momentum within psychology, and then in the 1970s William T Powers brought the notion of servo-control to perception in his book, "Behavior: The Control of Perception." Since then, scientists have come to see nature not as linear chain of contingent cause-effect relationships, but rather, as a non linear, unpredictable nesting of self referential, emergent coordinations, best described as Chaos theory. The implications for perception are astounding, while maintaining the double-aspect nature of perception espoused by the Gestalt psychologists. In short, system theories model perception within the context of a functioning organism, so that objects of experience come to be seen as scale-dependent, psychophysically-neutral, phenomenological transformations of energy structures, the dynamics of which are the result of evolution, and therefore, "a priori" to the individual case. This "a priori," homological unity among brain perception and world is revealed through the use of systems theories and represents the thrust of this book. All the authors are applying some sort of systems theory to the psychology of perception. However, unlike Dewey we have close to a century of technology we can bring to bear upon the issue. This book should be seen as a collection of such efforts.

The Newnes Know It All Series takes the best of what our authors have written to create hard-working desk references that will be an engineer's first port of call for key information, design techniques and rules of thumb. Guaranteed not to gather dust on a shelf!
Part I Fundamentals of Sound
Chapter 1 Audio Principles
Chapter 2. Measurement
Chapter 3 Acoustic Environment
II. Audio Electronics
Chapter 4 Components
Chapter 5 Power supply design

III Preamplifiers and Amplifiers
Chapter 6 Introduction to Audio Amplification
CHAPTER 7 Preamplifiers and input signals
Chapter 8 Interfacing and processing
Chapter 9 Audio amplifiers
Chapter 10 Audio amplifier
Chapter 11. Valve (tube-based) amplifiers
Chapter 12 Negative feedback
Chapter 13 Noise and grounding
Part IV Digital Audio
Chapter 14 Digital audio fundamentals
Chapter 15 Representation of Audio Signals
Chapter 16.Compact disc
Chapter 17 Digital audio recording basics
Chapter 18 Digital audio interfaces
Chapter 19 Data compression
Chapter 20 Digital audio production
Chapter 21 Other Digital Audio Devices
V. Microphone and Loudspeaker Technology
Chapter 22 Microphone technology
Chapter 23 Loudspeakers
Chapter 24 Loudspeaker enclosures
Chapter 25 Headphones
Part VI. Sound Reproduction Systems
Chapter 26 Tape Recording
Chapter 27 Recording consoles
Chapter 28 Video synchronization
Chapter 29 Room acoustics
Part VII Audio Test and Measurement
CHAPTER 30 Fundamentals and instruments
- A 360-degree view from our best-selling authors
- Hot topics covered
- The ultimate hard-working deskreference; all the essential information, techniques and tricks of the trade in one volume

Its basic empirical research and investigation of pure theories of investment in the sports and lottery markets make this volume a winner. These markets are simpler to study than traditional financial markets, and their expected values and outcomes are uncomplicated. By means of new overviews of scholarship on the industry side of racetrack and other betting markets to betting exchanges and market efficiencies, contributors consider a variety of sports in countries around the world. The result is not only superior information about market forecasting, but macro- and micro-analyses that are relevant to other markets.
* Easily studied sports markets reveal features relevant for more complex traditional financial markets
* Significant coverage of sports from racing to jai alai
* New studies of betting exchanges and Internet wagering markets

The material collected in this volume discusses the present as well as expected future directions of development of the field with particular emphasis on applications. The seven survey articles present different topics in Evolutionary PDE s, written by leading experts.
- Review of new results in the area
- Continuation of previous volumes in the handbook series covering Evolutionary PDEs
- Written by leading experts

Clinical trials are an important part of medicine and healthcare today, deciding which treatments we use to treat patients. Anyone involved in healthcare today must know the basics of running and interpreting clinical trial data. Written in an easy-to-understand style by authors who have considerable expertise and experience in both academia and industry, this book covers all of the basics of clinical trials, from legal and ethical issues to statistics, to patient recruitment and reporting results.
*Jargon-free writing style enables those with less experience to run their own clinical trials and interpret data.
*Book contains an ideal mix of theory and practice so researchers will understand both the rationale and logistics to clinical trial medicine.
*Expert authorship whose experience includes running clinical trials in an academic as well as industry settings.
*Numerous illustrations reinforce and elucidate key concepts and add to the book's overall pedagogy.

Nonlinear optics is the study of the interaction of intense laser light with matter. The third edition of this textbook has been rewritten to conform to the standard SI system of units and includes comprehensively updated material on the latest developments in the field.
The book introduces the entire field of optical physics and specifically the area of nonlinear optics. It focuses on the fundamental issues including the electromagnetic origin of optical phenomena, the quantum mechanical description of the optical properties of matter, the role of spatial symmetries in determining the optical response, causality and Kramers Kronig relations, and ultrafast and high intensity optical effects. The book also covers applied aspects of nonlinear optics such as harmonic generation, the operation of parametric oscillators, optical switching, photonics, materials issues in nonlinear optics, and processes such as laser damage that can restrict the use of nonlinear optics.
This edition contains new material on:
- Applications of harmonic generation including applications within the fields of microscopy and biophotonics
- Electromagnetically induced transparency
- Spectroscopy based on coherent anti-Stokes Raman scattering (CARS)

Nonlinear Optics appeals to a wide audience of physics, optics, and electrical engineering students, as well as to working researchers and engineers. Those in related fields, such as materials science and chemistry, will also find this book of particular interest.
* Presents an introduction to the entire field of optical physics from the perspective of nonlinear optics.
* Combines first rate pedagogy with a treatment of fundamental aspects ofnonlinear optics
* Covers all the latest topics and technology in this ever-evolving industry
* Strong emphasis on the fundamentals

*Just months after the introduction of the new generation of 32-bit PIC microcontrollers, a Microchip insider and acclaimed author takes you by hand at the exploration of the PIC32
*Free CD-ROM includes source code in C and the Microchip MPLAB C32 compiler
*Includes handy checklists to help readers perform the most common programming and debugging tasks
The new 32-bit microcontrollers bring the promise of more speed and more performance while offering an unprecedented level of compatibility with existing 8 and 16-bit PIC microcontrollers. In sixteen engaging chapters, using a parallel track to his previous title dedicated to 16-bit programming, the author puts all these claims to test while offering a gradual introduction to the development and debugging of embedded control applications in C.
Author Lucio Di Jasio, a PIC and embedded control expert, offers unique insight into the new 32-bit architecture while developing a number of projects of growing complexity.
Experienced PIC users and newcomers to the field alike will benefit from the text s many thorough examples which demonstrate how to nimbly side-step common obstacles, solve real-world design problems efficiently and optimize code using the new PIC32 features and peripheral set.
You will learn about:
*basic timing and I/O operation
*debugging methods with the MPLAB SIM *simulator and ICD tools
*multitasking using the PIC32 interrupts
*all the new hardware peripherals
*how to control LCD displays
*experimenting with the Explorer16 board and *the PIC32 Starter Kit
*accessing mass-storage media
*generating audio and video signals
*and more
TABLE OF CONTENTS
Day 1 And the adventure begins
Day 2 Walking in circles
Day 3 Message in a Bottle
Day 4 NUMB3RS
Day 5 Interrupts
Day 6 Memory
Part 2 Experimenting
Day 7 Running
Day 8 Communication
Day 9 Links
Day 10 Glass = Bliss
Day 11 It s an analog world
Part 3 Expansion
Day 12 Capturing User Inputs
Day 13 UTube
Day 14 Mass Storage
Day 15 File I/O
Day 16 Musica Maestro
*32-bit microcontrollers are becoming the technology of choice for high performance embedded control applications including portable media players, cell phones, and GPS receivers.
*Learn to use the C programming language for advanced embedded control designs and/or learn to migrate your applications from previous 8 and 16-bit architectures.
*All code examples and software tools required to get acquainted with Microchip s MPLAB development environment, and to complete all the projects described in the book, are offered in the attached CDROM including the MPLAB C32 C Compiler (free Student Edition) and the full source code for more than 15 entertaining projects."

Nutritional Biochemistry takes a scientific approach to nutrition. It covers not just "whats"--nutritional requirements--but why they are required for human health, by describing their function at the cellular and molecular level. Each case study either leads to a subsequent discovery or enables an understanding of the physiological mechanisms of action of various nutrition-related processes. The text is "picture-oriented" and the commentary is directed towards explaining graphs, figures, and tables.
Nutritional Biochemistry includes a discussion of relevant aspects of physiology, food chemistry, toxicology, pediatrics, and public health. Experimental techniques for nutritional science are emphasized, and primary data is included to help give students a feel for the nutrition literature. This "real-world" approach provides students with a realistic view of the basis for much of our understanding of nutritional biochemistry.
* Integrates biochemistry and nutrition in a case-oriented method
* Emphasizes a hands-on approach to learning - case histories and clinical and research data illustrate all major points
* Places emphasis on metabolism - metabolic pathways, enzymology, nutrient requirements (including RDA values)
* Reveals the benefits of the Mediterranean diet, the biochemistry of exercise, the cell signaling pathways, how nutrition can influence the development of cancer, and the anthropometry and genetics of obesity.

"Adolescent Addiction: Epidemiology, Assessment, and Treatment" presents a comprehensive review of information on adolescent addiction, including prevalence and co-morbidity rates, risk factors to addiction, and prevention and treatment strategies. Unlike other books that may focus on one specific addiction, this book covers a wide range of addictions in adolescents, including alcohol, cannabis, tobacco, eating, gambling, internet and video games, and sex addiction. Organized into three sections, the book begins with the classification and assessment of adolescent addiction. Section two has one chapter each on the aforementioned addictions, discussing for each the definition, epidemiology, risk factors, co-morbidity, course and outcome, and prevention and intervention. Section three discusses the assessment and treatment of co-morbid conditions in greater detail as well as the social and political implications of adolescent addictions.
Intended to be of practical use to clinicians treating adolescent addiction, the book contains a wealth of information that will be of use to the researcher as well. Contributors to the book represent the US, Canada, the UK, New Zealand, and Australia.
About the Editor:
Cecilia A. Essau is professor of developmental psychopathology at Roehampton University in London, UK. Specializing in child and adolescent psychopathology, she has been an author or editor of 12 previous books in child psychopathology and is author of over 100 research articles and book chapters in this area.
* Comprehensive with the state-of-the-art information on important and the most common adolescent addiction
* Easy to understand and organized chapters
* Written by international experts

This book is both a set of procedures for the therapist and a philosophy- one that is shared with clients and one that guides the work of the therapist. This second edition continues its excellence in offering clinicians a guide to doing what works in brief therapy- for whom, and when and how to use it. Psychotherapy that follows these guidelines validates the client's most important concerns - and it often turns out to be surprisingly brief. Author, Ellen Quick integrates strategic and solution focused therapy and includes guidelines for tailoring technique and interventions to client characteristics and preferences. With clinically rich examples throughout, this book offers applications for couples, including indications for individual or conjoint sessions.
NEW TO THIS EDITION:
* Chapter summaries highlighting key points
* Presents ways of eliciting what clients most want to remember
* Describes the "Doing What Works Group," including outcome research findings and all materials needed to run the group
* Addresses the relationship between the positive psychology movement and this approach and the potential for collaboration
* Emphasizes an acceptance-based stance and how acceptance often leads to change
* Proposes that "doing what works and changing what doesn't" can provide a transtheoretical perspective for therapists of any orientation

Perfectly intelligent programmers often struggle when forced to work with SQL. Why? Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not to mention lost productivity.
This book will change the way you think about the problems you solve with SQL programs.. Focusing on three key table-based techniques, Celko reveals their power through detailed examples and clear explanations. As you master these techniques, you ll find you are able to conceptualize problems as rooted in sets and solvable through declarative programming. Before long, you ll be coding more quickly, writing more efficient code, and applying the full power of SQL
Filled with the insights of one of the world s leading SQL authorities - noted for his knowledge and his ability to teach what he knows.
Focuses on auxiliary tables (for computing functions and other values by joins), temporal tables (for temporal queries, historical data, and audit information), and virtual tables (for improved performance).
Presents clear guidance for selecting and correctly applying the right table technique."

As conceived by the founders of the Econometric Society, econometrics is a field that uses economic theory and statistical methods to address empirical problems in economics. It is a tool for empirical discovery and policy analysis. The chapters in this volume embody this vision and either implement it directly or provide the tools for doing so. This vision is not shared by those who view econometrics as a branch of statistics rather than as a distinct field of knowledge that designs methods of inference from data based on models of human choice behavior and social interactions. All of the essays in this volume and its companion volume 6A offer guidance to the practitioner on how to apply the methods they discuss to interpret economic data. The authors of the chapters are all leading scholars in the fields they survey and extend.
Handbook of Econometrics is now available online at ScienceDirect full-text online from volume 1 onwards.
*Part of the renowned Handbooks in Economics Series
*Updates and expands the exisiting "Handbook of Econometrics" volumes
*An invaluable reference written by some of the world's leading econometricians."

VHDL-2008: Just the New Stuff, as its title says, introduces the new features added to the latest revision of the IEEE standard for the VHDL hardware description language. Written by the Chair and Technical Editor of the IEEE working group, the book is an authoritative guide to how the new features work and how to use them to improve design productivity. It will be invaluable for early adopters of the new language version, for tool implementers, and for those just curious about where VHDL is headed.
* First in the market describing the new features of VHDL 2008;
* Just the new features, so existing users and implementers can focus on what's new;
* Helps readers to learn the new features soon, rather than waiting for new editions of complete VHDL reference books.
* Authoritative, written by experts in the area;
* Tutorial style, making it more accessible than the VHDL Standard Language Reference Manual.

Edited by Rajnish Mehra, this volume focuses on the equity risk premium puzzle, a term coined by Mehra and Prescott in 1985 which encompasses a number of empirical regularities in the prices of capital assets that are at odds with the predictions of standard economic theory.

The classic book "The Art of War" (or as it is sometimes translated, "The Art of Strategy") by Sun Tzu is often used to illustrate principles that can apply to the management of business environments. "The Art of War for Security Managers" is the first book to apply the time-honored principles of Sun Tzu's theories of conflict to contemporary organizational security.
Corporate leaders have a responsibility to make rational choices that maximize return on investment. The author posits that while conflict is inevitable, it need not be costly. The result is an efficient framework for understanding and dealing with conflict while minimizing costly protracted battles, focusing specifically on the crucial tasks a security manager must carry out in a 21st century organization.
* Includes an appendix with job aids the security manager can use in day-to-day workplace situations
* Provides readers with a framework for adapting Sun Tzu's theories of conflict within their own organizations
* From an author who routinely packs the room at his conference presentations

There has been recently some interdisciplinary convergence on a number of precise topics which can be considered as prototypes of complex systems. This convergence is best appreciated at the level of the techniques needed to deal with these systems, which include:
1) A domain of research around a multiple point where statistical physics, information theory, algorithmic computer science, and more theoretical (probabilistic) computer science meet: this covers some aspects of error correcting codes, stochastic optimization algorithms, typical case complexity and phase transitions, constraint satisfaction problems.
2) The study of collective behavior of interacting agents, its impact on understanding some types of economical and financial problems, their link to population and epidemics dynamics, game theory, social, biological and computer networks and evolution.
The present book is the written version of the lectures given during the Les Houches summer school session on "Complex Systems," devoted to these emerging interdisciplinary fields. The lectures consist both in a number of long methodological courses (probability theory, statistical physics of disordered systems, information theory, network structure and evolution, agent-based economics and numerical methods) and more specific, 'problem oriented' courses. Lecturers are all leading experts in their field; they have summarized recent results in a clear and authoritative manner. The "Les Houches lecture notes" have a long tradition of excellence and are often found to be useful for a number of years after they were written.
The book is of interest to students and researchers with various backgrounds: probability theory, computer science, information theory, physics, finance, biology, etc.
.Topical and comprehensive survey of the emerging, interdisciplinary field of "Complex Systems," covered by recognized world experts
."Les Houches lectures notes": a long tradition of excellence and long-lasting impact
.Of interest to a broad audience (mathematics, physics, biology, informatics, finance, geology, etc.)
.Some applications may have concrete impact
.Selected topics in complex systems: forefront of research in the field"

Network routing can be broadly categorized into Internet routing, PSTN routing, and telecommunication transport network routing. This book systematically considers these routing paradigms, as well as their interoperability. The authors discuss how algorithms, protocols, analysis, and operational deployment impact these approaches. A unique feature of the book is consideration of both macro-state and micro-state in routing; that is, how routing is accomplished at the level of networks and how routers or switches are designed to enable efficient routing.
In reading this book, one will learn about 1) the evolution of network routing, 2) the role of IP and E.164 addressing in routing, 3) the impact on router and switching architectures and their design, 4) deployment of network routing protocols, 5) the role of traffic engineering in routing, and 6) lessons learned from implementation and operational experience. This book explores the strengths and weaknesses that should be considered during deployment of future routing schemes as well as actual implementation of these schemes. It allows the reader to understand how different routing strategies work and are employed and the connection between them. This is accomplished in part by the authors' use of numerous real-world examples to bring the material alive.
. Bridges the gap between theory and practice in network routing, including the fine points of implementation and operational experience
. Routing in a multitude of technologies discussed in practical detail, including, IP/MPLS, PSTN, and optical networking
. Routing protocols such as OSPF, IS-IS, BGP presented in detail
. A detailed coverage of various router and switch architectures
. A comprehensive discussion about algorithms on IP-lookup and packet classification
. Accessible to a wide audience due to its vendor-neutral approach
. CD-ROM with bonus chapters on advanced topics

This book contains the written versions of lectures delivered since 1997 in the well-known weekly seminar on Applied Mathematics at the College de France in Paris, directed by Jacques-Louis Lions. It is the 14th and last of the series, due to the recent and untimely death of Professor Lions.
The texts in this volume deal mostly with various aspects of the theory of nonlinear partial differential equations. They present both theoretical and applied results in many fields of growing importance such as Calculus of variations and optimal control, optimization, system theory and control, operations research, fluids and continuum mechanics, nonlinear dynamics, meteorology and climate, homogenization and material science, numerical analysis and scientific computations
The book is of interest to everyone from postgraduate, who wishes to follow the most recent progress in these fields.

"18.07"

The fourth edition contains seven new sections with chapters on General Relativity, Gravitational Waves and Relativistic Cosmology. The text has been thoroughly revised and additional problems inserted.

The Complete course of Theoretical Physics by Landau and Lifshitz, recognized as two of the world's outstanding physicists, is published in full by Butterworth-Heinemann. It comprises nine volumes, covering all branches of the subject; translations from the Russian are by leading scientists.

WIth the ongoing pressures for psychologists to practice evidence-based care, and the requirement insurance carriers have both for treatment goals, measurement of outcomes, and a focus on brief therapy, functional analysis provides a framework for achieving all of the above. Having proven itself in treating behavioral problems in education, functional analysis is now being applied more broadly to behavioral and psychologial disorders.
In his 1996 book (Functional Analysis in Clinical Psychology, Wiley UK), Sturmey applied the functional behavioral approach to case formulation across a wide range of psychological disorders and behaviors. Since the publication of his book, no other volume has taken an explicit behavioral approach to case formulation. The changes that have occurred over the last 10 years in behavioral case formulation have been significant and substantial. They include (a) a large expansion of the range of problems addressed, such as ADHD, (b) a range of new verbal behavior therapies such as Acceptance and Commitment Therapies, (c) increased area of activity in the area of autism spectrum disorders; (d) many publications in how to train professionals, staff and parents in behavioral technology, and (e) new assessment instruments and procedures.
*Makes theories of functional analysis accessible to a wide range of mental health professionals
*Reviews behavioral assessment methods and strategies for case formulation
*Offers readers a practical, organized, data-based means of understanding psychiatric conditions for intervening effectively and measuring positive change

This edited book examines some of the current inquiry related to the study of emotions in educational contexts. There has been a notable increased interest in educational research on emotions.
Emotion in Education represents some of the most exciting and current research on emotions and education, and has the potential to impact research in this area. This combination of variety, timeliness, potential for transformation of the field, and uniqueness make this a "must-have" resource for academics in the fields of education, educational psychology, emotion psychology, cultural psychology, sociology, and teacher education.
The chapters have been written for scholars in the area, but authors also wrote with graduate students in mind. Therefore, the book is also be a great volume for graduate seminars.
*Provides in-depth examination of emotions in educational contexts
*Includes international roster of contributors who represent a variety of disciplines
*Represents a number of different research approaches

The main purpose of this volume is to provide a new perception of multivariate environmental statistics using some examples that are of concern and interest today. The papers are presented by outstanding research workers. They discuss the current state of the art in different areas of multivariate environmental statistics and provide new problems for future research and instruction. A perspective is to cover a broad spectrum of methods and issues involving multivariate observations and processes, and not just classical multivariate analysis. The book will be valuable to current statistical theory and practice in this area, and will be used by researchers, teachers, and students alike.

Protein NMR Spectroscopy combines a comprehensive theoretical treatment of NMR spectroscopy with an extensive exposition of the experimental techniques applicable to proteins and other biological macromolecules in solution. Beginning with simple theoretical models and experimental techniques, Protein NMR Spectroscopy develops the complete repertoire of theoretical principles and experimental techniques necessary for understanding and implementing the most sophisticated NMR experiments.
Important new techniques and applications of NMR spectroscopy have emerged since the first edition of this extremely successful book was published in 1996. The second edition includes new sections describing measurement and use of residual dipolar coupling constants for structure determination, TROSY and deuterium labeling for application to large macromolecules, and experimental techniques for characterizing conformational dynamics. In addition, the treatments of instrumentation and signal acquisition, field gradients, multidimensional spectroscopy, and structure calculation are updated and enhanced.
Protein NMR Spectroscopy is written as a graduate-level textbook and will be of interest to biochemists, chemists, biophysicists, and structural biologists who utilize NMR spectroscopy or who wish to understand the latest developments in this field.
. Provides an understanding of the theoretical principles important for biological NMR spectroscopy
. Demonstrates how to implement, optimize and troubleshoot modern multi-dimensional NMR experiments
. Allows for the capability of designing effective experimental protocols for investigations of protein structures and dynamics
. Includes a comprehensive set of example NMR spectra of ubiquitin provides a reference for validation of experimental methods"

Exposure Therapy refers to any clinical intervention in which a client directly confronts a source of fear. Since high levels of anxiety can not be maintained indefinitely, repeated exposure leads to decreased anxiety. This type of treatment is effective with phobias, post traumatic stress disorder, obsessive compulsive disorders, panic, generalized anxiety, and several other disorders. It's also been found to be effective in helping to treat substance abuse. Although exposure-based treatments have been extensively researched and reported in the literature, there is no single comprehensive treatment of exposure therapies. Writings tend to be limited to larger pieces on treating specific disorders or types of patients. A comprehensive book on the use of these treatments across patient disorders will be of great use to practitioners.
The book is divided into three sections: Foundation, Applications, and Issues. Foundation chapters considers theoretical and assessment issues. Applications chapters will discuss research literature on each disorder having been proven to be successfully treated with exposure therapy. Issue chapters will discuss liability issues, false memory syndrome, and the use of computers and virtual reality in exposure therapy.
*Covers the broad range of exposure therapies in one comprehensive source
*Provides an integrated look at exposure therapy across a variety of disorders
*Each such chapter will include a case study
*Blends literature review and practice guidelines

In this complete revision and expansion of his first SQL Puzzles book, Joe Celko challenges you with his trickiest puzzles and then helps solve them with a variety of solutions and explanations. Joe demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but help develop the mindset needed to solve the many difficult SQL puzzles you face every day. Of course, part of the fun is to see whether or not you can write better solutions than Joe s.
* A great collection of tricky SQL puzzles with a variety of solutions and explanations.
* Uses the proven format of puzzles and solutions to provide a user-friendly, practical look into SQL programming problems - many of which will help users solve their own problems.
* New edition features:
Many new puzzles added
Dozens of new solutions to puzzles, and using features in SQL-99
Code is edited to conform to SQL STYLE rules
New chapter on temporal query puzzles
New chapter on common misconceptions about SQL and RDBMS that leads to problems"