The following SQL statement filters data based on ____ SELECT * FROM customers WHERE Country = "Germany";

Q:

Which of the following SQL statements adds a $2.00 service fee to the total price in a table called “Orders”, that lists the price of orders customers placed with a store?

Q:

What does the following SQL statement do? SELECT total / 2 FROM Orders;

Q:

The following SQL statement returns 2 percent of the total price: SELECT total % 2 FROM Orders;

Q:

Which of the following SQL statements returns 50% of the total price? Choose all correct answers.

Q:

Select the right SQL statement to display the values of the total prices that are greater than $140.

Q:

Does the following SQL statements sort the result-set of the total prices in ascending or descending order? SELECT * FROM Orders ORDER BY total;

Q:

The following SQL statement filters data based on ____ SELECT * FROM customers WHERE Country = “Germany”;

Q:

In SQL you can sort records in descending order using the DESCENDING keyword.

Q:

The output of the following SQL query within the Orders table is: UK, UK, UK, France, France, Finland SELECT DISTINCT Country FROM Orders;

Q:

What does the following SQL statement do? SELECT * FROM Orders ORDER BY country, total;

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments