ISDD - SQL

Question 1

How would you create a table in SQL?

Answer 1

CREATE TABLE aa characters (id INTEGER PRIMARY KEY, forename STRING, surname STRING, age_(during SoJ) INTEGER, job STRING);

Question 2

How do you insert a record into a table using SQL?

Answer 2

INSERT INTO aa characters

VALUES (1, “Phoenix”, “Wright”, 35, “Defense Attorney”);

Question 3

How do you delete a record from a table using SQL?

Answer 3

DELETE FROM aa characters

WHERE forename = “Matt” AND surname = “Engarde”;

Question 4

How do you update a table in SQL?

Answer 4

UPDATE aa characters
SET age = 27
WHERE forename = “Ema” AND surname = “Skye”;

Question 5

What is the algorithm for running a query, say on defence attorneys using SQL?

Answer 5

SELECT * FROM aa characters

WHERE job = “Defense Attorney”;

Question 6

How do you display a table and all of its contents using SQL?

Answer 6

SELECT * FROM aa characters;

Question 7

How would you order a queries results using SQL?

Answer 7

…

ORDER BY age [ASC/DESC];

Question 8

How would you use a COUNT function to find out how many of each thing you have in a query using SQL?

Answer 8

SELECT job, COUNT(job) AS number
FROM aa characters
GROUP BY job;

Question 9

How would you rename a field in a query in SQL?

Answer 9

… job AS occupation …;