To establish a range of values, can be used.

To establish a range of values, < and > can be used.

Introduction to SQL
To establish a range of values, < and > can be used.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The keyword LIKE can be used in a WHERE clause to refer to a range of values.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following is a SQL aggregate function?

AVG

LEFT

JOIN

LEN

AVG

LEFT

JOIN

LEN

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70oF.

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

NOT IN only.

IN only.

LIKE only.

Both IN and NOT IN.

NOT IN only.

IN only.

LIKE only.

Both IN and NOT IN.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following do you need to consider when you make a table in SQL?

Primary keys

All of these

Data types

Default values

Primary keys

All of these

Data types

Default values

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL To establish a range of values, < and > can be used.

Introduction to SQL The keyword LIKE can be used in a WHERE clause to refer to a range of values.

Introduction to SQL Which of the following is a SQL aggregate function?

Introduction to SQL Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70oF.

Introduction to SQL When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

Introduction to SQL Which of the following do you need to consider when you make a table in SQL?

Introduction to SQL
To establish a range of values, < and > can be used.

Introduction to SQL
The keyword LIKE can be used in a WHERE clause to refer to a range of values.

Introduction to SQL
Which of the following is a SQL aggregate function?

Introduction to SQL
Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70oF.

Introduction to SQL
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

Introduction to SQL
Which of the following do you need to consider when you make a table in SQL?