Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE inventory ( film_id VARCHAR )
TABLE: CREATE TABLE film ( title VARCHAR, film_id VARCHAR, rental_rate VARCHAR )

### Question ###
Which film is rented at a fee of 0.99 and has less than 3 in the inventory? List the film title and id.

### Accurate SQL ###

SELECT title, film_id FROM film WHERE rental_rate = 0.99 INTERSECT SELECT T1.title, T1.film_id FROM film AS T1 JOIN inventory AS T2 ON T1.film_id = T2.film_id GROUP BY T1.film_id HAVING COUNT(*) < 3