CREATE TABLE table_name_46 (not_usable NUMBER, retired VARCHAR2, launch_failures VARCHAR2)

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_name_46 WHERE retired = 0 AND launch_failures < 1
SELECT AVG("not_usable") FROM "table_name_46" WHERE "launch_failures" < 1 AND "retired" = 0