*SQL QUESTION*

I couldn't get the correct answer from my solutions, may i know what's wrong with them? Thank you. (left panel is the question, my solution is on the right)

1) How to use EXTRACT() function to answer this question?

2) I coundn't pass the larger dataset.

3) I counldn't firgure out this question. thanks

Your task is to write an SQL query that determines the number of films that have been released in the last 10 years (including SELECT EXTRACT (year FROM CURRENT TIMESTAMP) FROM FiLm WHERE release yearCURRENT TIMESTAMP; the current year). Your query's result should have a single column called count. Note: Do not assume a specific year for your query. Write a same query would also work next year without modification. generic query using the current system clock so that the Film Film Actor Cou country id fim id title actor id first name rc casc ycar rental duration rental rate replacement cost im id ent ca special features language id original languago id DSubmissions >Output psql : query.sq1 : 3 : ERROR: operator does not exist: smallint LINE 3: WHERE release year CURRENT_TIMESTAMP; name timestamp with time zone Overview of the tables in the film database schema