Table: player_stats_22
Columns: name
country
transfer_window
transfer_fee
apps
goals

Question: what is the apps when the name is smith?
SQL: SELECT MIN("apps") FROM player_stats_22 WHERE "name" = 'smith'

Question: how many times is the transfer fee £2,500,000?
SQL: SELECT COUNT("goals") FROM player_stats_22 WHERE "transfer_fee" = '£2,500,000'

Question: how many times is the transfer window, summer and the name sinclair?
SQL: SELECT COUNT("apps") FROM player_stats_22 WHERE "transfer_window" = 'summer' AND "name" = 'sinclair'

Question: what is the goals when the country is wal, the name is smith and apps is more than 0?
SQL: SELECT SUM("goals") FROM player_stats_22 WHERE "country" = 'wal' AND "name" = 'smith' AND "apps" > 0