Table: player_transfers_3
Columns: nat
name
moving_from
type
transfer_window
ends
transfer_fee

Question: What is the type for Cassano?
SQL: SELECT "type" FROM player_transfers_3 WHERE "name" = 'cassano'

Question: What nationality is Diogo?
SQL: SELECT "nat" FROM player_transfers_3 WHERE "name" = 'diogo'

Question: What is the name of the player with a winter transfer window moving from Roma?
SQL: SELECT "name" FROM player_transfers_3 WHERE "transfer_window" = 'winter' AND "moving_from" = 'roma'