Analytics/SQL Flashcards
1
Q
What does the * mean
A
all
2
Q
what does “select” control
A
the columns
3
Q
what does “where” control
A
restricts the rows
4
Q
what does “from” control
A
it specifies the data set
5
Q
what does the “order by” control
A
display order
6
Q
What does “having” control
A
it restricts rows based on aggregate column
7
Q
What does AS do
A
makes column aliases use quotes around alias to make it easy, you can remove as and it still works to alias
8
Q
what does inner join do
A
it just gives common data
9
Q
what does left outer join do
A
gives all data on the left and anything on the right that matches
10
Q
Good technique:break it down from the innermost quert
A
alsoa good idea to know query 1400 and practice makes perfect
11
Q
Group by the____
A
Non aggregates
