sql

Question 1

create a table called flights

Answer 1

create table flights (
id integer primary key autoincrement,
origin text not null,
destination text not null,
duration integer not null
);

Question 2

insert values into flights

Answer 2

insert into flights (origin, destination, duration) values (“NY”, “London”, 400);

Question 3

select specific columns from flights

Answer 3

select column1, column2 FROM flights

Question 4

select specific rows from flights

Answer 4

select * from flights where id = 3
(can be any value of any column, like “New York”)

Question 5

select specific rows from flights with conditions

Answer 5

select * from flights where duration > 500 AND destination = “Paris”;

Question 6

select multiple rows based on conditions

Answer 6

select * from flights where origin IN (“New York” , “Paris”);

Question 7

select rows similar to value

Answer 7

select * from flights WHERE origin LIKE “%a%”;
(all things that have an “a” in them)

Question 8

update values in DB

Answer 8

UPDATE flights SET duration = 500
WHERE origin = “New York”
AND destination = “London”;

Question 9

delete data

Answer 9

DELETE FROM flights WHERE destination = “Tokyo”;

Question 10

other clauses

Answer 10

LIMIT
ORDER BY
GROUP BY
HAVING