CREATE TABLE table_41159 ("Rank" CLOB, "Nation" CLOB, "Gold" FLOAT, "Silver" FLOAT, "Bronze" FLOAT, "Total" FLOAT)

Where does Norway rank in total medals among countries with fewer than 7 bronzes?
SELECT "Rank" FROM table_41159 WHERE "Bronze" < '7' AND "Nation" = 'norway'
SELECT "Rank" FROM "table_41159" WHERE "Bronze" < '7' AND "Nation" = 'norway'