JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.
Quick Check 4.3 – Data 100, Summer 2020
Sign in to Google
to save your progress.
Learn more
* Indicates required question
(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;
*
0
1
2
3
4
What is the output of the following query: SELECT COUNT(DISTINCT bname) from Boats;
*
0
1
2
3
4
Submit
Clear form
This form was created inside of UC Berkeley.
Report Abuse
Forms
