SELECT
date,
people_fully_vaccinated AS 'Australia'
FROM vaccinations
WHERE location = 'Australia';
SELECT
date,
people_fully_vaccinated AS 'United States'
FROM vaccinations
WHERE location = 'United States';
SELECT
date,
people_fully_vaccinated AS 'France'
FROM vaccinations
WHERE location = 'France';
SELECT
date,
people_fully_vaccinated AS 'Israel'
FROM vaccinations
WHERE location = 'Israel';
uj5u.com熱心網友回復：
如果您不關心每個國家/地區的數字在不同的行中，您可以使用：
select date,
location,
people_fully_vaccinated
from vaccinations
where location in ('Australia','United States','France','Israel');
如果您希望每個國家/地區的數字顯示在每個日期的同一行上，您可以使用：
select date,
sum(case when location = 'Australia' then people_fully_vaccinated else 0 end) as "Australia",
sum(case when location = 'United States' then people_fully_vaccinated else 0 end) as "United States",
sum(case when location = 'France' then people_fully_vaccinated else 0 end) as "France",
sum(case when location = 'Israel' then people_fully_vaccinated else 0 end) as "Israel"
where location in ('Australia','United States','France','Israel')
group by date;
uj5u.com熱心網友回復：
你已經有位置作為國家名稱。所以不需要選擇列people_fully_vaccinated
如果您想按特定國家/地區過濾，請使用以下內容：
SELECT date
,location
FROM vaccinations
WHERE location = 'Australia'
OR location = 'United States'
OR location = 'France'
OR location = 'Israel'
如果你想得到所有，那么在下面使用：
SELECT date,location FROM vaccinations;
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/345393.html