Formating Cost

[kristinekene]

Activity 7.02 *;
* 1) Complete the SQL query to display Event and Cost *;
* from PG1.STORM_DAMAGE. Format the values of Cost. *;
* 2) Add a new column named Season that extracts the *;
* year from Date. *;
* 3) Add a WHERE clause to return rows where Cost is *;
* greater than 25 billion. *;
* 4) Add an ORDER BY clause to arrange rows by *;
* descending Cost. Which storm had the highest *;
* cost?

Can someone assist ? How do I format the value of Cost to Billions ?

Thank you

[Reeza]

What do you mean by format the cost to Billions?
$3,000,000,000 or $3B?

[kristinekene]

It doesnt specify. 3B?

[Reeza]

Have you learned to create custom formats in your course or do you think they'd want you to use an available format? What have you learned about formats so far?

[kristinekene]

I think that they would want us to use available formats.

[Reeza]

Then they probably want just a dollar format:

format yourVariable $dollar32.;