Basics

Question 1

What is a table schema?

Answer 1

Contains all the relationships between tables excluding data

*useful for testing without importing confidential information

Question 2

What is used to end a clause/statement?

Answer 2

;

Question 3

What is the basic syntax that forms a SELECT statement?

Answer 3

SELECT FROM ;

Question 4

How do you select multiple things with a SELECT statement?

Answer 4

SELECT ,,;

Question 5

What can be used to select unique values only in a table?

Answer 5

DISTINCT

SELECT DISTINCT FROM ;

Question 6

What can be used to perform logic on values returned from SELECT?

Answer 6

WHERE

i.e: SELECT FROM WHERE = ;

Question 7

What are the operators for a WHERE statement?

Answer 7

=
>
<
>=
<=
!= or <>
AND
OR

Question 8

How do you reference a string when performing logic with WHERE?

Answer 8

enclose in single quotes

‘’

Question 9

What syntax can be used to count the number of rows returned by a SELECT statement?

Answer 9

COUNT
i.e:
SELECT COUNT(*) FROM ;
SELECT COUNT(DISTINCT ) FROM ;

Question 10

What syntax can be used to limit the number of rows returned by a query?

Answer 10

LIMIT

SELECT FROM LIMIT ;

Question 11

What is the syntax to order columns returned something in ascending or descending order?

Answer 11

ORDER BY

SELECT FROM ORDER BY ;

Question 12

Why would you ORDER BY for multiple columns?

Answer 12

If the first columns are identical the second ordering will take effect
i.e:
SELECT FROM ORDER BY ASC, ASC;

Question 13

What is one unique aspect of PostgreSQL compared to other databases?

Answer 13

It allows sorting of information that is not explicitly stated in the SELECT clause