Exercicios SQL
Exercicios SQL
('E1011','08/01/2000','760','8'),
('E1012','08/01/2001','720','8'),
('E1013','08/16/2001','720','9'),
('E1014','08/16/2000','720','9'),
('E1015','05/30/2000','500','8'),
('E1016','08/16/2001','600','2'),
('E1017','05/30/2002','650','7'),
('E1018','05/06/2010','700','7'),
('E1019','08/16/2016','780','10'),
('E1020','08/16/2016','780','8');
Select *
FROM EMPLOYEES
WHERE CAST(strftime('%Y', current_date) AS INTEGER) - CAST(substr(b_date,7,4) AS
INTEGER) >= 40
and sex = 'M';
SELECT *,
case
WHEN CAST(strftime('%Y', current_date) AS INTEGER) -
CAST(substr(start_date,7,4) AS INTEGER) >= 10
THEN salary * 1.25
ELSE salary
END AS PLR
FROM EMPLOYEES
INNER JOIN JOB_HISTORY ON EMPLOYEES.emp_id = JOB_HISTORY.EMPL_ID;
SELECT *,
substr(b_date,7,4) AS ANO_NASCIMENTO,
substr(start_date,7,4) AS ANO_INICIO_TRABALHO
FROM 'Tabelao';
SELECT *,
f_name || " " || l_name AS NOME_CONCAT
FROM EMPLOYEES;