Gordon Linoff questions

Gordon Linoff answers

• Use Multiple conditions in Case Statement
• Foreign key composed of 2 columns with specific values
• with clause execution order
• Compare dates in different columns and rows dynamically in SQL
• How to do both is not null and a not in statement in sql (oracle)?
• Select top 4 scores by person but need at least two locations
• SQL, combine two tables with distinct values only (based on only three fields, not entire row)
• Calculate cumulative percentiles using SQL for a group/partition
• Referencing ROW_NUMBER() in WHERE
• mysql how to select maximum value of a column as another column in the resultset