SQL

Question 1

Cannot use Having without:

Answer 1

Group by, because its a group level filtering criteria.

Question 2

What are the BIG 6 ELEMENTS of a sql query?

Answer 2

1) SELECT: identifies the columns.
2) FROM: identifies the table
3) WHERE: filter your results
4) GROUP BY: how to group the data.
5) HAVING: group filtering criteria
6) ORDER BY: order of the displayed results.

Question 3

Which two components of a query are absolutly essential?

Answer 3

Select and from.

Question 4

What is the USE statement?

Answer 4

You tell the query which database it should query. You can avoid having to use the USE statement if you set the default database to the one you are using.