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
0 Comments
Find Questions in This Page: "CTRL+F"
