Table: legzdins
Columns: name
country
type
moving_from
transfer_window
ends
transfer_fee

Question: What transfer fee did Birmingham City get on 30 June 2010?
SQL: SELECT "transfer_fee" FROM legzdins WHERE "ends" = '30 june 2010' AND "moving_from" = 'birmingham city'

Question: What type of move was Elding from ENG?
SQL: SELECT "type" FROM legzdins WHERE "country" = 'eng' AND "name" = 'elding'

Question: When does Donaldson's move end?
SQL: SELECT "ends" FROM legzdins WHERE "name" = 'donaldson'