Real SQL Queries: 50 Challenges

Real SQL Queries: 50 Challenges

<h2>Sharpen your SQL Skill with Real-World Practice.</h2><p>Queries improve when challenges are authentic. This book sets your learning on the fast track with realistic problems to solve. Topics span sales, marketing, human resources, purchasing, and production.<i> Real SQL Queries: 50 Challenges</i> is perfect for analysts, report writers, or anyone searching for a hands-on approach to learning SQL Server.</p><h2>Why this Book?</h2> <ul> <li><u>Get Started Quickly</u>. All challenges are based on AdventureWorks2012, Microsoft’s universally-accessible sample database. AdventureWorks is free to download and intuitive to explore. </li><li><u>Solve Real Problems</u>. Studying concepts is useful, but nothing accelerates skill faster than a hands-on, problem-solution approach. </li><li><u>Learn by Example</u>. Every challenge includes a fully documented solution. </li><li><u>Lots of Helping Hands</u>. Not sure how to begin? Each question includes a hint to set you in the right direction. </li><li><u>Something for Everyone</u>. Difficulty varies from challenge to challenge; it’s truly a mixed bag. </li><li><u>Freshen your Technique</u>. Solutions exhibit a wide range of functions and approaches, so you’re sure to find something new. </li><li><u>Your Teaching Companion</u>. Ready-to-go material for SQL tutors, trainers, and college professors. </li></ul><h2>Preview of Challenges to Solve:</h2> <p></p><ul> <li><u>Year over Year Comparisons</u>: An executive requests data concerning fiscal quarter sales by salesperson. She'd like to see comparisons from the fiscal quarters of 2008 to the same fiscal quarters of 2007. </li><li><u>Ten Million Dollar Benchmark</u>: Ten million dollars of revenue is a common benchmark for Adventure Works. For each fiscal year (2007 and 2008) find the first dates when the cumulative running revenue total hit $10 million. </li><li><u>Expired Credit Cards</u>: The Accounting department found instances where expired credit cards were used with sales orders. You are asked examine all credit cards and report the extent of such activity. </li><li><u>The Mentors</u>: The Vice President of Sales wants the five most successful sales people to mentor the five least successful sales people. Create a list of sales people to match with one another. </li><li><u>Online/Offline</u>: Create a summary table that shows, by territory, the percentage of orders placed online in comparison to orders not placed online. </li></ul><h3><p>Solutions to challenge questions available for download. Details inside.</p></h3>