select count(player_name) as player_count from football_players ; select substring(player_name,1,3) from football_players; select player_name,substring(player_name,4 ...
LEFT(first_name,2) AS first_2_letters_from_the_left, RIGHT(first_name,3) AS first_3_letters_from_the_right, SUBSTRING(first_name,2) AS starting_from_the_second_letter ...