Blog

Which of the following was true of the American economy during Clinton’s presidency?

Rosa Parks’s decision not to give up her seat on December 1, 1955, was __________.

In an SQL query of two tables, which SQL keyword indicates that we want data from all the rows of one table to be included in the result, even if the row does not correspond to any data in the other table?

In an SQL query, which SQL keyword is used to determine if a column value is equal to any one of a set of values?

What was the correct sequence of historical database development?

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.