Table: fernando_orsi
Columns: name
club
date_of_departure
replacement
date_of_appointment

Question: Tell me the club with a replacement of alberto malesani
SQL: SELECT "club" FROM fernando_orsi WHERE "replacement" = 'alberto malesani'

Question: Name the club with date of appointment of 1 november 2007
SQL: SELECT "club" FROM fernando_orsi WHERE "date_of_appointment" = '1 november 2007'