1
Q
What are some examples of aggregate functions?
A
add() , sum(), count(), min(), max(), ave() … etc
2
Q
What is the purpose of a group by clause?
A
to keep column subjects grouped together
Coding
flashcards
Decks in class (79)
# Cards
-
Html Block and Inline4
-
Html Forms4
-
Html Lists2
-
Html Relative Links4
-
HTML Skeleton4
-
Html Syntax3
-
Html Tables3
-
CSS Box Model3
-
CSS Cascade5
-
CSS Colors1
-
CSS Flex Box2
-
CSS Fonts2
-
CSS Layout Classes5
-
CSS Media Queries2
-
CSS Positioning6
-
CSS Pseudo Classes2
-
CSS Responsive Layout3
-
CSS Syntax4
-
CSS Transforms2
-
CSS Transitions1
-
Javascript Arrays6
-
Javascript Forms3
-
Javascript Functions7
-
Javascript If7
-
Javascript Loops10
-
Javascript methods14
-
Javascript Objects5
-
Javascript Operators and Expressions4
-
Javascript Primitives And Variables12
-
Javascript View Swapping7
-
Dom creation7
-
Dom-events8
-
DOM Event Delegation6
-
Dom manipulation7
-
DOM Querying12
-
Javscript and Json5
-
Javascript Custom Methods10
-
Javascript-this8
-
JavaScript Prototypes4
-
JavaScript Timers5
-
Http Messages8
-
JavaScript Ajax5
-
es6 Const Let6
-
ES6 Template Literals2
-
Command Line Basics4
-
Node Intro6
-
Node Process3
-
Node Process Agrv4
-
The Event Loop2
-
es6-promises3
-
ES6 Destructuring4
-
Node Module System4
-
Node FS readfile5
-
express-intro4
-
Express Hello World4
-
Express Get Json2
-
Postgres Intro5
-
postgres-database4
-
SQL select9
-
SQL insert4
-
Sql join3
-
Sql Delete2
-
sql-aggregates2
-
ES6 Classes6
-
webpack-and-babel4
-
React Elements3
-
React JSX2
-
React Components3
-
react-props-and-expressions4
-
react-events4
-
react-state6
-
React-form-controls6
-
React Rendering Lists6
-
Fetch4
-
Fetch in React5
-
react Context5
-
React Custom Hooks5
-
unit-tests-jest4
-
JavaScript Closure6
