#1 Vārdi un datumi ar manu vārda dienas nedēļu
SELECT NAME, 
date(CONCAT(YEAR(CURRENT_DATE), '-', MONTH, '-', DAY)) AS full_date
FROM ricardsstaskevicsdb.namsday WHERE WEEK (date(CONCAT(YEAR(CURRENT_DATE), '-', MONTH, '-', DAY)),1)  =
(SELECT	WEEK (date(CONCAT(YEAR(CURRENT_DATE), '-', MONTH, '-', DAY)),1) AS full_date
FROM ricardsstaskevicsdb.namsday WHERE NAME LIKE 'Reinis')
ORDER BY MONTH,DAY

#2 Vārdi un datumi, kas ir tikpat gari kā mans vārds
SELECT NAME, DATE(CONCAT(YEAR(CURRENT_DATE), '-', MONTH, '-', DAY)) AS full_date
FROM ricardsstaskevicsdb.namsday
WHERE LENGTH(NAME) = LENGTH('Reinis')

#3 Vārdi un datumi, kas ir tikpat gari kā mans uzvārds
SELECT NAME, DATE(CONCAT(YEAR(CURRENT_DATE), '-', MONTH, '-', DAY)) AS full_date
FROM ricardsstaskevicsdb.namsday
WHERE LENGTH(NAME) = LENGTH('Buls')

#4 Vārdi un datumi, kas sākas un beidzas ar mana vārda buritem
SELECT NAME, DATE(CONCAT(YEAR(CURRENT_DATE), '-', MONTH, '-', DAY)) AS full_date
FROM ricardsstaskevicsdb.namsday
WHERE (left(NAME,1) = left('Reinis',1)) AND (right(NAME,1) = right('Reinis',1))

#5 Vārdi un datumi, kas sākas ar mana vārda pēdējo burtu
SELECT NAME, DATE(CONCAT(YEAR(CURRENT_DATE), '-', MONTH, '-', DAY)) AS full_date
FROM ricardsstaskevicsdb.namsday
WHERE (left(NAME,1) = right('Reinis',1))

#6 Vārdi un datumi, kam vārdadiena ir pēc 7 mēnešiem
SELECT n1.name,
date(CONCAT(YEAR(CURRENT_DATE), '-', n1.MONTH, '-', n1.DAY)) AS full_date
FROM namsday n1 
LEFT JOIN (SELECT n1.name, 
month(DATE_ADD(date(CONCAT(YEAR(CURRENT_DATE), '-', n1.MONTH, '-', n1.DAY)), INTERVAL n1.DAY MONTH)) AS men,
day(DATE_ADD(date(CONCAT(YEAR(CURRENT_DATE), '-', n1.MONTH, '-', n1.DAY)), INTERVAL n1.DAY MONTH)) AS dien
FROM namsday n1 WHERE n1.NAME = 'reinis' ) AS d
ON d.men=n1.`month` AND d.dien=n1.`day`
WHERE  NOT ISNULL(d.name)
ORDER BY n1.`month`,n1.`day`

#7 Vārdi un datumi, kas sākas ar mana vārda pirmo burtu, kārtojot mēnešus dilstoši, datumus augoši
SELECT NAME, DATE(CONCAT(YEAR(CURRENT_DATE), '-', MONTH, '-', DAY)) AS full_date
FROM ricardsstaskevicsdb.namsday
WHERE (left(NAME,1) = left('Reinis',1)) 
ORDER BY month DESC, day ASC;

#8 Vārdi un datumi, kas sākas ar mana vārda pēdējo burtu un ir decembrī
SELECT NAME, DATE(CONCAT(YEAR(CURRENT_DATE), '-', MONTH, '-', DAY)) AS full_date
FROM ricardsstaskevicsdb.namsday
WHERE (left(NAME,1) = right('reinis',1)) AND 
MONTH = (SELECT month 
FROM ricardsstaskevicsdb.namsday
WHERE NAME = 'reinis')

#9 Garākie vārdi, kas sākas un beidzas ar mana vārda burtiem katrā mēnesī
SELECT NAME, DATE(CONCAT(YEAR(CURRENT_DATE), '-', MONTH, '-', DAY)) AS full_date
FROM ricardsstaskevicsdb.namsday
WHERE (left(NAME,1) = left('Reinis',1)) AND (right(NAME,1) = right('Reinis',1)) 
GROUP BY MONTH
ORDER BY LENGTH(NAME) DESC, MONTH 

#10 Vecums dienās, mēnešos un gados
SELECT DATEDIFF(CURDATE(), '2007-12-15') AS dienas, TIMESTAMPDIFF(MONTH, '2007-12-15', CURDATE()) AS menesi, TIMESTAMPDIFF(YEAR, '2007-12-15', CURDATE()) AS gadi;