Table: player_transfer_4
Columns: name
country
type
moving_from
transfer_window
transfer_fee

Question: Name the country for pieroni
SQL: SELECT "country" FROM player_transfer_4 WHERE "name" = 'pieroni'

Question: Name the country for 6-month loan and moving from of lens
SQL: SELECT "country" FROM player_transfer_4 WHERE "type" = '6-month loan' AND "moving_from" = 'lens'

Question: Name the transfer fee with a transfer window of summer for schollen
SQL: SELECT "transfer_fee" FROM player_transfer_4 WHERE "transfer_window" = 'summer' AND "name" = 'schollen'

Question: Name the name that has moving of 1. fc nürnberg.
SQL: SELECT "name" FROM player_transfer_4 WHERE "moving_from" = '1. fc nürnberg'

Question: Name the country with polák
SQL: SELECT "country" FROM player_transfer_4 WHERE "name" = 'polák'