Table: issf_worldcup_scores
Columns: shooter
prone
stand
kneel
qual

Question: What is the highest kneel with a stand less than 187, and a 197 prone, and a qual more than 576?
SQL: SELECT MAX("kneel") FROM issf_worldcup_scores WHERE "stand" < 187 AND "prone" = 197 AND "qual" > 576

Question: What is the sum of the stand with a qual more than 589?
SQL: SELECT SUM("stand") FROM issf_worldcup_scores WHERE "qual" > 589