Table: grand_prix_motorcycle_2008
Columns: team
constructor
motorcycle
tyre
rider
rounds

Question: Who was Constructor for rider Marco Melandri?
SQL: SELECT "constructor" FROM grand_prix_motorcycle_2008 WHERE "rider" = 'marco melandri'

Question: Anthony West ride which Motorcyle?
SQL: SELECT "motorcycle" FROM grand_prix_motorcycle_2008 WHERE "rider" = 'anthony west'