Saved

Consider the following table.

Students

SID	SFirstName	SLastName	SState
1	John	Lee	OH
2	Marry	McDonlad	TX
3	Steven	Johnson	TX

What is the result of the following query?

SELECT SID, FROM Students WHERE SState= 'TX'

Question 20 options:

SID	SFirstName	SLastName	SState
1	John	Lee	OH
3	Steven	Johnson	TX

SID	SFirstName	SLastName	SState
1	John	Lee	OH
2	Marry	McDonlad	TX

SID	SFirstName	SLastName	SState
2	Marry	McDonlad	TX
3	Steven	Johnson	TX

SID	SFirstName	SLastName	SState
1	John	Lee	OH
2	Marry	McDonlad	TX
3	Steven	Johnson	TX

Question 21 (1 point)

Saved

Consider the following tables.

Customers

CustID	CustName	CustCity	CustState
1	Coca Cola	Dallas	TX
2	Apple	Houston	TX
3	GE	Dallas	TX
4	Ford	Houston	TX

What is the result of the following query?

SELECT DISTINCT CustCity FROM Customers

Question 21 options:

	CustCity Dallas Houston
	CustCity Dallas Houston Dallas Houston
	CustCity Dallas Dallas Houston
	CustCity Dallas Houston Houston

Question 22 (1 point)

Saved

Consider the following table.

Products

ProductID	ProductName	Price
1	Syrup	18
2	Gumbo Mix	19
3	Apple	10
4	Tomato	22
5	Chicken	24

What is the result of the following query?

SELECT * FROM Products WHERE Price BETWEEN 10 AND 20;

Question 22 options:

ProductID	ProductName	Price
1	Syrup	18
2	Gumbo Mix	19
3	Apple	10

ProductID	ProductName	Price
1	Syrup	18
2	Gumbo Mix	19
5	Chicken	24

ProductID	ProductName	Price
3	Apple	10
4	Tomato	22
5	Chicken	24

ProductID	ProductName	Price
1	Syrup	18
2	Gumbo Mix	19
3	Apple	10
4	Tomato	22
5	Chicken	24

Question 23 (1 point)

Saved

Consider the following table.

Products

ProductID	ProductName	Category	Price
21	Apple	A	10
22	Banana	B	12
24	Grape	C	11

What is the output of the following query?

SELECT * FROM Products WHERE Category in ('A','B')

Question 23 options:

ProductID	ProductName	Category	Price
21	Apple	A	10
22	Banana	B	12

ProductID	ProductName	Category	Price
22	Banana	B	12
24	Grape	C	11

ProductID	ProductName	Category	Price
21	Apple	A	10
22	Banana	B	12
24	Grape	C	11

ProductID	ProductName	Category	Price
21	Apple	A	10
24	Grape	C	11

Question 24 (1 point)

Saved

Consider the following table.

Products

ProductID	ProductName	Category	Price
21	Apple	A	10
22	Banana	B	12
24	Grape	C	11
23	Orange	A	11
25	Corn	B	25

What is the output of the following query?

SELECT * FROM Products where ID < 24 AND Category = 'A'

Question 24 options:

ProductID	ProductName	Category	Price
22	Banana	B	12
25	Corn	B	25

ProductID	ProductName	Category	Price
21	Apple	A	10
22	Banana	B	12
24	Grape	C	11
25	Corn	B	25

ProductID	ProductName	Category	Price
21	Apple	A	10
24	Grape	C	11

ProductID	ProductName	Category	Price
21	Apple	A	10
23	Orange	A	11

Question 25 (1 point)

Saved

Consider the following table.

Products

ProductID	ProductName	Category	Price
21	Apple	A	10
22	Banana	B	12
24	Grape	C	11
23	Orange	A	11
25	Corn	B	25

What is the output of the following query?

SELECT * FROM Products where ProductID = 22

Question 25 options:

ProductID	ProductName	Category	Price
22	Banana	B	12

ProductID	ProductName	Category	Price
21	Apple	A	10
22	Banana	B	12

ProductID	ProductName	Category	Price
23	Orange	A	11
25	Corn	B	25

ProductID	ProductName	Category	Price
21	Apple	A	10
22	Banana	B	12