Bartu Bozkurt bartubozkurt

## fetch_allcolumns.sql
SELECT * FROM country;

## fetch_id_name.sql
SELECT id, name FROM city;

## name_sorted_rating_asc.sql
SELECT name FROM city ORDER BY rating ASC;

## name_sorted_rating_desc.sql
SELECT names FROM city ORDER BY rating DESC;

## as_columns.sql
SELECT name AS city_name FROM city;

## as_table.sql
SELECT co.name, ci.name
FROM city AS ci
JOIN  country AS co
  ON ci.country_id = co.id;

## operators.sql
SELECT name FROM city WHERE rating > 3;

## sql_!.sql
SELECT name
FROM city
WHERE name != 'Berlin' AND  name != 'Madrid';

## text_operators.sql
SELECT name
FROM city
WHERE name LIKE 'P%' OR name LIKE '%s';

## text_operators_2.sql
SELECT name
FROM city
WHERE name LIKE '_ublin';
	SELECT co.name, ci.name
	FROM city AS ci
	JOIN country AS co
	ON ci.country_id = co.id;
	SELECT name
	FROM city
	WHERE name != 'Berlin' AND name != 'Madrid';