SQL queries

Question 1

SELECT

Answer 1

The SELECT statement is used to select data from a database.

Question 2

WHERE

Answer 2

The WHERE clause is used to filter records that match a certain
condition

Question 3

ORDER BY

Answer 3

The ORDER BY keyword is used to sort the result-set in
ascending (ASC) or descending (DESC) order.

Question 4

IN

Answer 4

The IN operator allows you to specify multiple values in a WHERE
clause, shorthand for multiple OR conditions.

Question 5

COUNT

Answer 5

number of rows returned based on your query

Question 6

MIN/MAX

Answer 6

minimum/maximum value of column

Question 7

AVG

Answer 7

average value of a column

Question 8

GROUP BY

Answer 8

The GROUP BY statement groups rows that have the
same values into summary rows, usually used with aggregate
functions (count, min/max, avg)

Question 9

HAVING

Answer 9

Same as WHERE, but used for aggregate functions

Question 10

INNER JOIN

Answer 10

selects records that have matching values in different tables.

Question 11

SUBQUERIES

Answer 11

A subquery is a query nested within another query

Question 12

CREATE

Answer 12

Used to create a new table in a
database

Question 13

DROP

Answer 13

Used to drop (delete) a table
from a database

Question 14

ALTER

Answer 14

Used to add/delete/modify columns
in an existing table

Question 15

INSERT

Answer 15

INSERT INTO is used to add a
new record to a table

Question 16

UPDATE

Answer 16

UPDATE modifies an existing
record in a table

Question 17

DELETE

Answer 17

DELETE will delete existing
records in a table