Questão 1423331

SELECT AUTORID, FIRSTNAME, LASTNAME

FROM AUTHORS

WHERE LASTNAME LIKE “SUZAN”;

SELECT AUTHORID, FIRSTNAME, LASTNAME

FROM AUTHORS ASC

ORDER BY “LASTNAME”;

SELECT FIRSTNAME, LASTNAME, ISBN

FROM AUTHORS

ORDER BY LASTNAME, FIRSTNAME;

INSERT INTO AUTHORS (FIRSTNAME,

LASTNAME)

VALUES FOR (‟SUE‟; ‟SMITH‟);

UPDATE AUTHORS ON LASTNAME = ‟JONES‟

WHERE LASTNAME = ‟SMITH‟ AND

FIRSTNAME = ‟SUE‟;