#1

INSERT INTO artists (name)
VALUES
	('Bud Powell');

#2

SELECT
	artistid,
	name
FROM
	artists
ORDER BY
	artistid DESC
LIMIT 1;

#3

INSERT INTO artists (name)
VALUES
	("Buddy Rich"),
	("Candido"),
	("Charlie Byrd");

#4

SELECT
	artistid,
	name
FROM
	artists
ORDER BY
	artistid DESC
LIMIT 3;

#5

INSERT INTO artists DEFAULT VALUES;

#6

SELECT
	artistid,
	name
FROM
	artists
ORDER BY
	artistid DESC;

#7

CREATE TABLE artists_backup(
	artistid INTEGER PRIMARY KEY AUTOINCREMENT,
	name NVARCHAR
);

#8

INSERT INTO artists_backup SELECT
	artistid,
	name
FROM
	artists;

#9

SELECT
	*
FROM
	artists_backup;