Description
Please help me to answer some question as I attached below in word
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