Table: charles_c_smith
Columns: name
reign
days_held
location
defenses

Question: What is the days held the champion with a reign larger than 3 and 1 defense has?
SQL: SELECT "days_held" FROM charles_c_smith WHERE "reign" > 3 AND "defenses" = 1

Question: What is the days held the champion with a reign larger than 3 and less than 1 defense has?
SQL: SELECT "days_held" FROM charles_c_smith WHERE "reign" > 3 AND "defenses" < 1

Question: What is the average defenses a champion with 404 days held and a reign larger than 1 has?
SQL: SELECT AVG("defenses") FROM charles_c_smith WHERE "days_held" = '404' AND "reign" > 1

Question: What is the lowest defense a champion with 345 days held has?
SQL: SELECT MIN("defenses") FROM charles_c_smith WHERE "days_held" = '345'