Did you try SQL Cookbook?

I think that was the one I used to enjoy.

Lots of receipts. The first are quite simple but the later, more advanced ones should take you way beyond simple joins and would also have variations for the most common databases.

From the table of contents:

...

Chapter 5 Metadata Queries
Listing Tables in a Schema
Listing a Table's Columns
Listing Indexed Columns for a Table
Listing Constraints on a Table
Listing Foreign Keys Without Corresponding Indexes
Using SQL to Generate SQL
Describing the Data Dictionary Views in an Oracle Database
Chapter 6 Working with Strings
Walking a String
Embedding Quotes Within String Literals
Counting the Occurrences of a Character in a String
Removing Unwanted Characters from a String
Separating Numeric and Character Data
Determining Whether a String Is Alphanumeric
Extracting Initials from a Name
Ordering by Parts of a String
Ordering by a Number in a String
Creating a Delimited List from Table Rows
Converting Delimited Data into a Multi-Valued IN-List
Alphabetizing a String
Identifying Strings That Can Be Treated as Numbers
Extracting the nth Delimited Substring
Parsing an IP Address
Chapter 7 Working with Numbers
Computing an Average
Finding the Min/Max Value in a Column
Summing the Values in a Column
Counting Rows in a Table
Counting Values in a Column
Generating a Running Total
Generating a Running Product
Calculating a Running Difference
Calculating a Mode
Calculating a Median
Determining the Percentage of a Total
Aggregating Nullable Columns
Computing Averages Without High and Low Values
Converting Alphanumeric Strings into Numbers
Changing Values in a Running Total
Chapter 8 Date Arithmetic
Adding and Subtracting Days, Months, and Years
Determining the Number of Days Between Two Dates
Determining the Number of Business Days Between Two Dates
Determining the Number of Months or Years Between Two Dates
Determining the Number of Seconds, Minutes, or Hours Between Two Dates
Counting the Occurrences of Weekdays in a Year
Determining the Date Difference Between the Current Record and the Next Record
Chapter 9 Date Manipulation
Determining if a Year Is a Leap Year
Determining the Number of Days in a Year
Extracting Units of Time from a Date
Determining the First and Last Day of a Month
Determining All Dates for a Particular Weekday Throughout a Year
Determining the Date of the First and Last Occurrence of a Specific Weekday in a Month
Creating a Calendar
Listing Quarter Start and End Dates for the Year
Determining Quarter Start and End Dates for a Given Quarter
Filling in Missing Dates
Searching on Specific Units of Time
Comparing Records Using Specific Parts of a Date
Identifying Overlapping Date Ranges
Chapter 10 Working with Ranges
Locating a Range of Consecutive Values
Finding Differences Between Rows in the Same Group or Partition
Locating the Beginning and End of a Range of Consecutive Values
Filling in Missing Values in a Range of Values
Generating Consecutive Numeric Values
Chapter 11 Advanced Searching
Paginating Through a Result Set
Skipping n Rows from a Table
Incorporating OR Logic when Using Outer Joins
Determining Which Rows Are Reciprocals
Selecting the Top n Records
Finding Records with the Highest and Lowest Values
Investigating Future Rows
Shifting Row Values
Ranking Results
Suppressing Duplicates
Finding Knight Values
Generating Simple Forecasts
Chapter 12 Reporting and Warehousing
Pivoting a Result Set into One Row
Pivoting a Result Set into Multiple Rows
Reverse Pivoting a Result Set
Reverse Pivoting a Result Set into One Column
Suppressing Repeating Values from a Result Set
Pivoting a Result Set to Facilitate Inter-Row Calculations
Creating Buckets of Data, of a Fixed Size
Creating a Predefined Number of Buckets
Creating Horizontal Histograms
Creating Vertical Histograms
Returning Non-GROUP BY Columns
Calculating Simple Subtotals
Calculating Subtotals for All Possible Expression Combinations
Identifying Rows That Are Not Subtotals
Using Case Expressions to Flag Rows
Creating a Sparse Matrix
Grouping Rows by Units of Time
Performing Aggregations over Different Groups/Partitions Simultaneously
Performing Aggregations over a Moving Range of Values
Pivoting a Result Set with Subtotals
Chapter 13 Hierarchical Queries
Expressing a Parent-Child Relationship
Expressing a Child-Parent-Grandparent Relationship
Creating a Hierarchical View of a Table
Finding All Child Rows for a Given Parent Row
Determining Which Rows Are Leaf, Branch, or Root Nodes
Chapter 14 Odds 'n' Ends
Creating Cross-Tab Reports Using SQL Server's PIVOT Operator
Unpivoting a Cross-Tab Report Using SQL Server's UNPIVOT Operator
Transposing a Result Set Using Oracle's MODEL Clause
Extracting Elements of a String from Unfixed Locations
Finding the Number of Days in a Year (an Alternate Solution for Oracle)
Searching for Mixed Alphanumeric Strings
Converting Whole Numbers to Binary Using Oracle
Pivoting a Ranked Result Set
Adding a Column Header into a Double Pivoted Result Set
Converting a Scalar Subquery to a Composite Subquery in Oracle
Parsing Serialized Data into Rows
Calculating Percent Relative to Total
Creating CSV Output from Oracle
Finding Text Not Matching a Pattern (Oracle)
Transforming Data with an Inline View
Testing for Existence of a Value Within a Group

Appendix A Window Function Refresher
Grouping
Windowing
Appendix B Rozenshtein Revisited
Rozenshtein's Example Tables
Answering Questions Involving Negation
Answering Questions Involving "at Most"
Answering Questions Involving "at Least"
Answering Questions Involving "Exactly"
Answering Questions Involving "Any" or "All"