format String in SQL statement.

[Steven]

That worked. I now have it working using your suggestions. Here's the updated code so other people may be helped.

query = 'select title, rental_rate, rental_date, return_date, rental_duration\
   FROM film JOIN inventory using(film_id)\
   JOIN rental using(inventory_id)\
   JOIN customer using(customer_id)\
   WHERE last_name = ? AND rental_date LIKE ?'
   print('Query',query)

   
   for row in db.execute(query,['%name%','%month%']):
       print(row)
       
       return row
       
   
   
leo = film_list('Ebert', 6, 2005) 

Now onto throwing it into a list in the for loop!