Query Select Columns « Select Query « Oracle PL / SQL

1.Query returning all rows and all columns from the table
2.Indicate the column names in query command
3.Returning a Single Column.sql
4.Reference one column more than once
5.Reference renamed column in order by
6.Renaming a column with a longer name
7.Return course name for an employee id