3f P1

Question 1

select

Answer 1

SELECT(nom-campos)
from (tabla)
WHERE(Condicion)
o
SELECT*
FROM(tabla)
WHERE(condicion)

Question 2

<>

Answer 2

diferente

Question 3

Min

Answer 3

min de columna
SELECT MIN(columna)
FROM(tabla)
WHERE (condiclon)

Question 4

MAX

Answer 4

max de columna

SELECT MAX(columna)
FROM(tabla)
WHERE (condiclon)

Question 5

count

Answer 5

SELECT COUNT(columna)
FROM(Tabla)
WHERE(condicion)

Question 6

AVG

Answer 6

SELECT AVG(columna)
FROM(tabla)
WHERE (condiclon)

Question 7

SUM

Answer 7

SELECT SUM(columna)
FROM(tabla)
WHERE (condiclon)

Question 8

SUM

Answer 8

SELECT SUM(columna)
FROM(tabla)
WHERE (condición)

Question 9

INSERT INTO

Answer 9

INSERT INTO tabla
(columnas)
VALUES(v1..v2..v3)

Question 10

INSERT INTO

Answer 10

INSERT INTO tabla

VALUES(v1..v2..v3);

Question 11

DELETE

Answer 11

DELETE FROM(tabla)
WHERE condicion;