APEX question

Description

Please help me to answer some question as I attached below in word

Don't use plagiarized sources. Get Your Custom Assignment on
APEX question
From as Little as $13/Page

Unformatted Attachment Preview

1. Determine the Appropriate Function and Write a QUERY:

Choose a table that has a column with a number data type. I chose D-CDs table

Then return the rounded average of that column.
─ You may choose what decimal place to round to. Select two options (creating two
output columns)
My Query:
Select
ROUND(AVG(CD_NUMBER), 4) AS AveragePriceRoundedTo4,
ROUND(AVG(CD_NUMBER), 0) AS AveragePriceRoundedTo0
From D_CDs;
Be practical when choosing your column. For what type of numeric data would it be useful to
have an average????
Please help me this answer based on the answer above
2. Determine the Appropriate Function and Write a QUERY:

Choose a table, choose a column in the table that allows and has null values and replace (in
your query) the null values with any value you select (use same data type).
Explain what you did.
2. Determine the Appropriate Command and Write a QUERY:


Choose a table with a column that has repetitive values. Choose any column in any table
and determine how many DISTINCT rows there are in that column.
Indicate what values were repeating to justify your logic.

Purchase answer to see full
attachment