CREATE TABLE table_40907 ("Block" CLOB, "Launched" FLOAT, "Operational" FLOAT, "Not usable" FLOAT, "Retired" FLOAT, "Launch Failures" FLOAT)

What is the average number of not usable satellited when there are 0 retired, and the launch failures are less than 1?
SELECT AVG("Not usable") FROM table_40907 WHERE "Retired" = '0' AND "Launch Failures" < '1'
SELECT AVG("Not usable") FROM "table_40907" WHERE "Launch Failures" < '1' AND "Retired" = '0'