SQL/class 24.sql at main · hardikjhalani263/SQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
use world ;
select * from country ;
select name , continent from country where name like 'A%';

select name from country where name like '%a_a%';
select name , contains from country where continent = 'asia' and continent = 'africa' ;

select * from country where continent = 'africa' or indepyear = 1901 ;

select name , continent , upper(name) , lower(name) from country;

select name , continent , concat(continent, '-' , code , '-' , 'regex') from country ;

select name ,substr(name,2) from country;

select name  from country where substring(name , 1,1) = substring(continent, 1,1);

select name ,continent from country
where name like 'ALG%';
select name , trim(both 'a' from name ) from country ;

select name , population ,rpad(population , 9 ,'0') from country ;