As the Database Administrator you are to extract data from the database. A service manager needs your help extracting data from the Planets database. Therefore, after opening SSMS and accessing the Planets database, specify the basic SELECT statements you would use to retrieve the required information from the tables.

What commands would return all the rows and columns in the Planets table?

What commands would you type and execute to return only the planet_id, planet_name, and planet_date?

What commands would you type and execute to return rows where the word moon appears somewhere in the name?

In the existing query window, what commands would you use to add a column alias to the planet_name column to clarify it as the subcategory name?

In the existing query window, what command would you use to sort the previous result set?