I need to come up with a query that will show the percentage of a certain nationality in a given city
In a table, these are the given fields:
Id number of an individual
city code
nationality code
this is the sql code i have so far:
select distictrow popdata.citynum
count(*) from popdata
where...