What is the year of the first appearance of the Black Knights, who had less than 1 finals appearances?
CREATE TABLE table_name_38 (
    year_of_first_appearance VARCHAR,
    corps_name VARCHAR,
    number_of_finals_appearances VARCHAR
)
SELECT COUNT(year_of_first_appearance) FROM table_name_38 WHERE corps_name = "black knights" AND number_of_finals_appearances < 1
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is the year of the first appearance of the Black Knights, who had less than 1 finals appearances? ### Input: CREATE TABLE table_name_38 (
    year_of_first_appearance VARCHAR,
    corps_name VARCHAR,
    number_of_finals_appearances VARCHAR
) ### Response: SELECT COUNT(year_of_first_appearance) FROM table_name_38 WHERE corps_name = "black knights" AND number_of_finals_appearances < 1