Quick Check 4.3 – Data 100, Summer 2020

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

(Adapted from SQL Review Worksheet) Which of the following are true regarding SQL? *

SQL is a declarative language that specifies what to produce but not how to compute it.

The WHERE and HAVING clause can be used interchangeably as they perform the same operation.

Usually, it is a good idea to read a SQL query starting from the SELECT statement because that is the part that comes first.

Usually, it is a good idea to read the SELECT part of a SQL query after the FROM part.

You can perform joins in SQL using the FROM and WHERE clauses.

Required

Consider the following table called tables:

What is the output of the following query: SELECT COUNT(bname) from Boats; *

What is the output of the following query: SELECT COUNT(DISTINCT bname) from Boats; *

Submit

Clear form

This form was created inside of UC Berkeley.

Does this form look suspicious? Report