Vladislav Kudriašev Portfoolio

Select * from laps

1. Tingimused

select nimi, pikkus from laps

select nimi, pikku
from laps
WHERE pikkus >=175

select nimi, pikkus
from laps
WHERE pikkus >=175
ORDER by pikkus DESC;

select nimi
FROM laps
WHERE nimi like 'K%'

select nimi
FROM laps
WHERE nimi like '%e%'

select nimi, vanus
FROM laps
WHERE vanus between 5 and 10;

2. Agregaatfunktsioonid

SUM()

MIN()

MAX()

AVG() – keskmine

COUNT() – кол заполненных ячеек

SELECT AVG(pikkus) AS keskmine_pikkus
FROM laps

SELECT SUM(vanus) AS summarne_vanus
FROM laps

SELECT MIN(pikkus) AS minimaalne_pikkus, MAX(pikkus) AS maksimaalne_pikkus
from laps

select COUNT(*) as lasteArv
from laps
where synniLinn like 'Tallinn'

select nimi,vanus
from laps
order by vanus DESC;

SELECT * FROM laps, loom
WHERE laps.lapsID=loom.lapsID

SELECT * FROM laps INNER JOIN loom
ON laps.lapsID=loom.lapsID

SELECT laps.nimi, loom.loomaNimi
FROM laps INNER JOIN loom
ON laps.lapsID=loom.lapsID

SELECT l.nimi, m.loomaNimi
FROM laps l INNER JOIN loom m
ON l.lapsID=m.lapsID

SELECT l.nimi, m.loomaNimi
FROM laps l INNER JOIN loom m
ON l.lapsID=m.lapsID
WHERE m.loomaNimi like '%kass%';

XAMPP

select nimi, pikkus from laps;

select nimi, pikkus
from laps
WHERE pikkus >=175

select nimi, pikkus
from laps
WHERE pikkus >=175
ORDER by pikkus DESC;

select nimi
FROM laps
WHERE nimi like ‘K%’

select nimi
FROM laps
WHERE nimi like ‘%e%’

select nimi, vanus
FROM laps
WHERE vanus between 5 and 10;

SELECT AVG(pikkus) AS keskmine_pikkus
FROM laps

SELECT SUM(vanus) AS summarne_vanus
FROM laps

???

SELECT MIN(pikkus) AS minimaalne_pikkus, MAX(pikkus) AS maksimaalne_pikkus
from laps

select COUNT(*) as lasteArv
from laps
where synniLinn like ‘Tallinn’

select nimi,vanus
from laps
order by vanus DESC;

SELECT * FROM laps, loom
WHERE laps.lapsID=loom.lapsID

SELECT * FROM laps INNER JOIN loom
ON laps.lapsID=loom.lapsID

SELECT laps.nimi, loom.loomaNimi
FROM laps INNER JOIN loom
ON laps.lapsID=loom.lapsID

SELECT l.nimi, m.loomaNimi
FROM laps l INNER JOIN loom m
ON l.lapsID=m.lapsID

SELECT l.nimi, m.loomaNimi
FROM laps l INNER JOIN loom m
ON l.lapsID=m.lapsID
WHERE m.loomaNimi like ‘%kass%’;

UPDATE laps
SET pikkus=pikkus*1.1

UPDATE laps
SET synnilinn=’Tallinn’

UPDATE laps
SET vanus=17,silmadeVarv=’Sinine’,pikkus=175

SELECT * FROM laps

select top 3 nimi,pikkus
from laps
order by pikkus DESC;

select nimi,pikkus
from laps
order by pikkus DESC limit 3;