CREATE TABLE table_24893 ("English short name  ( upper/lower case ) " CLOB, "Alpha-2 code" CLOB, "Alpha-3 code" CLOB, "Numeric code" FLOAT, "ISO 3166-2 codes" CLOB)

What is the number reference for LIE?
SELECT "Numeric code" FROM table_24893 WHERE "Alpha-3 code" = 'LIE'
SELECT "Numeric code" FROM "table_24893" WHERE "Alpha-3 code" = 'LIE'