SQL Queries

 CREATE TABLE myTable (

  id SERIAL PRIMARY KEY,

  name varchar(255) default NULL,

  phone varchar(100) default NULL,

  email varchar(255) default NULL,

  country varchar(100) default NULL,

  region varchar(50) default NULL

);

select * from myTable;

select * from myTable

where country in('Philippines','United Kingdom');

select * from myTable

order by name Asc;

select * from myTable

where phone like '(%'

order by name Asc;

select * from myTable

where phone like '(%' and email like '%.net'

order by name Asc;

select count(name) as count_name

from myTable

where phone like '(%' and email like '%.net';