SQl学习之路：6

SELECT confirmed,deaths,recovered,recovered/confirmed,concat(round((recovered/confirmed)*100,2),'%')治愈率
FROM covid
where recovered/confirmed>0.3

SELECT distinct name,replace(name,'A','替换')替换
FROM covid

SELECT distinct name,replace(name,'a','替换')替换
FROM covid

SELECT distinct name,substring(name,2,3),substring(name,2)第二位全部
FROM covid

SELECT name,capital
FROM world
WHERE name = capital

SELECT name,capital,left(name,2),left(capital,2)
FROM world
where (left(name,2)=left(capital,2))and name<>capital

SELECT capital,name
FROM world
where capital like concat('%',name,'%') 
and name != capital