Zad1

SELECT * FROM company WHERE Name like 'p%'

Zad2

SELECT * FROM company
WHERE CityId = 1
AND PostCode like '5%';

Zad3

Pierwsze sposob:

SELECT * FROM company
WHERE YEAR(StartDate)=2000

Drugi sposob:

SELECT * FROM company
WHERE StartDate >='2000-01-01'
AND StartDate <= '2000-12-31'

Zad4

SELECT NAME, AnnualIncome,
AnnualIncome/12 As "Przychod miesieczny"
FROM company WHERE Active=1 AND EmployeeCount >= 1000

Zad5

Od najmiejszego do najwiekszego:

SELECT NAME, AnnualIncome/12
FROM company
order by AnnualIncome
limit 3

Od najwiekszego do najmniejszego:

SELECT NAME, AnnualIncome/12
FROM company
order by AnnualIncome desc
limit 3

Zad6

SELECT NAME FROM company
WHERE AnnualIncome/12 > 10000

Zad7

To zle:

SELECT * FROM company
WHERE PostCode IN ('54-621','78-695','63-896')

To zle x2:

SELECT NAME, PostCode, Street, Number
FROM company
WHERE PostCode IN ('54-621','78-695','63-896')

To dobrze:

SELECT
Name, PostCode,
concat(Street, " ",Number) As adres
FROM company
WHERE PostCode IN ('54-621','78-695','63-896')

Zad8

Jutro

Zad9