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 BETWEEN 14 AND 18 AND climb_stats.quality_average>2.9
ORDER BY climb_stats.quality_average DESC

Climbs with big deviation

SELECT climbs.name, climbs.setter_username, difficulty_grades.boulder_name, 
	climb_stats.display_difficulty - round(climb_stats.display_difficulty) AS "Deviation", 
	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>10 AND 
	climb_stats.difficulty_average BETWEEN 18 AND 19
	AND climb_stats.quality_average>2.5 AND
	(climb_stats.display_difficulty - round(climb_stats.display_difficulty) ) < -0.3
ORDER BY climb_stats.display_difficulty - round(climb_stats.display_difficulty) ASC