Select nimi, pikkus
from laps
where pikkus >=170

сортирует от большего к малому

select nimi
FROM laps
where nimi like 'M%';

select nimi
FROM laps
where nimi like '%s%';

select nimi, vanus
From laps
WHERE vanus between 10 and 15;
select nimi, vanus
From laps
WHERE vanus >= 10 and vanus <=15;

SELECT AVG(pikkus) AS keskmine_pikkus
FROM laps;

SELECT SUM(vanus) as 'summarne vanus'
FROM laps;

select MIN(pikkus) as minPikkus,
MAX(pikkus) as MaxPikkus
From laps;

select COUNT(*)
FROM laps
WHERE synnilinn like 'Tallinn';

Select top 1 nimi, vanus
from laps
order by vanus desc;

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

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

Minu SQL

SELECT SUM(pikkus) as ‘summarne pikkus’
FROM laps;

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

XAMPP

tables

Select

Select nimi, pikkus from laps where pikkus >=170 ORDER By pikkus Desc;

select nimi FROM laps where nimi like ‘M%’;

select nimi FROM laps where nimi like ‘%s%’;

select nimi, vanus From laps WHERE vanus >=10 and vanus <=15;

SELECT AVG (pikkus) AS keskmine_pikkus FROM laps;

SELECT SUM (vanus )as ‘summarne vanus’ FROM laps;

select MIN(pikkus) as minPikkus, MAX(pikkus) as MaxPikkus From laps;

select COUNT(*)FROM laps WHERE synnilinn like‘Tallinn’;

Select nimi, vanus from laps order by vanus desc;

SELECT lo.loomaNimi, l.nimiFROM laps l INNERJOIN loom lo ON l.lapsID=lo.lapsID;

WHERE lo.loomaNimi like '%kass%';