SQL HELP

a. Write a SELECT statement using a single table that includes an arithmetic calculation and a single row function(i.e TRUNC, ROUND, etc). Format the number using a conversion function and format model. Include a column alias to mask the calculation.

b. Write a SELECT statement listing 2 columns (after the SELECT key word). Include a GROUP function with a restriction. Specify the sort order.

c. Write 1 inner join using at least 3 tables and specify at least 1 restriction. If you do not have 3 related tables to support this, explain and work with 2 tables.

d. Write an outer join using at least 2 tables and specify a restriction. Make sure the data supports this. You may have to manipulate existing data.

e. Use NVL2, SOUNDEX, or CASE in a query.

f. Write a sub-query with 2 inner queries.