SQL Queries for Mere Mortals

This guide teaches SQL query writing through step-by-step instruction and includes the newest SQL standards and database applications. With sample databases, the book covers the basics of SQL, drawing data, creating expressions, sorting information, and filtering data. The book also covers advanced SQL topics such as subqueries, unlinked tables, and driver tables. In two new chapters, the book covers how to perform complex calculations and how to partition data. This guide is perfect for developers, DBAs, students, and users.