Blog

A _____ clause must come before a _____ clause.

In an SQL query, which SQL keyword is used with built-in functions to group together rows that have the same value in a specified column or columns?

The built-in function SUM can be used with any column.

Based on the tables below, which of the following commands would return only the name of the sales representative and the name of the customer for each customer that has a balance greater than 400?GENERAL SALES DATABASE:SALESREP SalesRepNo RepName HireDate 654 Jones 01/02/2005 734 Smith 02/03/2007 345 Chen 01/25/2018 434 Johnson 11/23/2004 CUSTOMER CustNo CustName Balance SalesRepNo 9870 Winston 500 345 8590 Gonzales 350 434 7840 Harris 800 654 4870 Miles 100 345  

Match the join terminology used by the book to the terminology used in lecture.

In an SQL query, which SQL keyword is used to state the condition that specifies which rows are to be selected?

In an SQL query, which built-in function is used to obtain the largest value of numeric columns?

When using the traditional set operators in a SELECT statement, tables must be union compatible and each corresponding column must have the same _____.

Based on the tables below, which of the following SQL commands would return the average customer balance grouped by SalesRepNo?GENERAL SALES DATABASE:SALESREP SalesRepNo RepName HireDate 654 Jones 01/02/2005 734 Smith 02/03/2007 345 Chen 01/25/2018 434 Johnson 11/23/2004 CUSTOMER CustNo CustName Balance SalesRepNo 9870 Winston 500 345 8590 Gonzales 350 434 7840 Harris 800 654 4870 Miles 100 345

SQL is a full, imperative programming language, like Python.