Deck 06: SQL

Deck 06: SQL

Q1. JOINs typically have ON clauses.  Say your ON clause is something like this:

Q2. If you only want to get the unique values in column C of table T, what SQL can you write?

Q3. What SQL clause lets you combine two tables?

Q4. What are two SQL clauses that let you filter down what rows are included based on some condition, and how do these two clauses differ?

Q5. What SQL clause pulls together related rows?

Q6. In SQL, SUM, AVG, and other operations that work over all rows (or groups of rows) are called ______

Q7. What SQL clause sorts rows?

Q8. What SQL clause lets you limit results to the first N rows?

Q9. What does ACID stand for?

Q10. If conn is a SQLAlchemy connection, and you’ve made some changes as part of a transaction, how do you finalize that transaction?

Q11. If conn is a SQLAlchemy connection, and you’ve made some changes as part of a transaction, how do you abandon that transaction?

Q12. What is a cross join?

Q13. What is a correlated cross join?