SESSION NAME: SQL Functions - 2.
QUESTION NAME: Round and Square root Function.
TABLE DESCRIPTION:
In this task, the user needs to write a query to implement
Round and Square root function.
Note: Use SQL in-built Function to calculate round and
square root function for items_ordered table.
The user needs to implement round and square root
function for the column price in items_ordered table.
Round the price method TWO digits.
Hint: round(price,2)
Input Format
The items_ordered table containing data for a company is
described as follows:
Round and Square root function.
Note: Use SQL in-built Function to calculate round and
square root function for items_ordered table.
The user needs to implement round and square root
function for the column price in items_ordered table.
Round the price method TWO digits.
Hint: round(price,2)
Input Format
The items_ordered table containing data for a company is
described as follows:
CODE:
select round(price,2), sqrt(price) from items_ordered;
4 Comments
Upload answer for
ReplyDeleteRound, Power and Square root Function
In this task, the user needs to write a query to implement Round, Power and Square root function. Note: Use SQL in-built Function to calculate round, power and square root function for station table. The user needs to implement round, power and square root function for the column lat_n and long_w and ID in customers table
Round the lat_n method to TWO digits. 1. Hint: round(lat_n , 2).
2. For power function: Use lat_n value as one parameter "x" value and the "y" as 5
Note: power(x,y) X= value denoted, lat_n and denotes="5"
Use long_w value as one parameter "x" value and the "y" as 7.
Note: power(x,y) X= value denoted, long_w and denotes="7"
3. Square root function for column ID. Input Format The station table is described as follows:
Thanks
We will try our best to get the answers. If u found the answer please leave a comment.
DeleteThis comment has been removed by the author.
ReplyDeleteQUESTION NAME: Round, Power and Square root Function
ReplyDeleteTABLE DESCRIPTION
In this task, the user needs to write a query to implement Round, Power and Square root function.
Note: Use SQL in-built Function to calculate round, power and square root function for station table.
The user needs to implement round, power and square root function for the column lat_n and long_w and ID in customers table
Round the lat_n method to TWO digits.
1. Hint: round(lat_n , 2).
2. For power function :
Use lat_n value as one parameter "x" value and the "y" as 5.
Note: power(x,y) X= value denoted , lat_n and Y denotes="5"
Use long_w value as one parameter "x" value and the "y" as 7.
Note: power(x,y) X= value denoted , long_w and Y denotes="7"
3. Square root function for column ID.
Input Format
The station table is described as follows:
Please sir give this question answer