SQLs

Kilters BMs

SELECT climbs.name, climbs.setter_username, difficulty_grades.boulder_name FROM climb_stats
JOIN difficulty_grades ON difficulty_grades.difficulty=climb_stats.benchmark_difficulty
JOIN climbs ON climbs.uuid=climb_stats.climb_uuid
WHERE climb_stats.angle=40 AND benchmark_difficulty IS NOT NULL
ORDER BY climb_stats.benchmark_difficulty

Climbs w/ highest quality rating

SELECT climbs.name, climbs.setter_username, difficulty_grades.boulder_name, climb_stats.quality_average, climb_stats.ascensionist_count
FROM climb_stats
JOIN difficulty_grades ON difficulty_grades.difficulty=round(climb_stats.display_difficulty)
JOIN climbs ON climbs.uuid=climb_stats.climb_uuid
WHERE climb_stats.angle=40 AND climb_stats.ascensionist_count>50 AND climb_stats.difficulty_average<18 AND climb_stats.quality_average>2.9
ORDER BY climb_stats.quality_average DESC