Baixe o app para aproveitar ainda mais
Prévia do material em texto
SELECT * FROM produtos WHERE preco BETWEEN 60 AND 120; SELECT AVG(preco) FROM produtos WHERE fabricante=2; SELECT AVG(preco), fabricante FROM produtos GROUP BY fabricante; ALTER TABLE Localization ADD region_id INT; SELECT FIRST_NAME, SALARY FROM Employees WHERE SALARY > 8000; SELECT SUM(SALARY) FROM employees; SELECT FIRST_NAME, PHONE_NUMBER FROM employees ORDER BY FIRST_NAME DESC; SELECT * FROM vendedores; CREATE TABLE funcionarios( matricula INT PRIMARY KEY NOT NULL AUTO_INCREMENTY, nome VARCHAR(250), email VARCHAR(150), hora DOUBLE NOT NULL ); SELECT DEPARTMENT_ID, SUM(SALARY) FROM employees GROUP BY DEPARTMENT_ID; SELECT nome, comissao FROM vendedores; CREATE TABLE paises( PAIS_ID VARCHAR(2), NOME_PAIS VARCHAR(40) );
Compartilhar