---
title: fc24.fact.ist / metrics
hide_title: true
---
```recs
select
*,
'https://cdn.fifacm.com/content/media/imgs/fc24/players/p'|| player_id::INTEGER::VARCHAR ||'.png' as player_img
from csv.fc24_players
```
```by_player
select
short_name,
player_img,
player_id,
nationality_name,
count(*) as total,
count(distinct club_name) as total_clubs,
avg(age) as average_age,
avg(height_cm) as average_height,
avg(weight_kg) as average_weight,
avg(overall) as average_rating,
avg(wage_eur) as average_wage,
avg(potential) as average_potential,
avg(value_eur) as average_value
from ${recs} recs
group by 1,2,3,4
limit 500
```
```by_country
with stats as (
select
nationality_id,
nationality_name,
avg(height_cm) as average_height,
avg(overall) as average_rating,
avg(pace) as average_pace,
avg(potential) as average_potential,
avg(value_eur) as average_value
from ${recs} recs
group by 1,2
)
select * from stats
limit 20
```
FC24 Metrics