1. List the asset number, type and description for all equipment where the date it was acquired is unknown. Phrasing this more formally, display the data in the assetNo, assetType and description...

1. List the asset number, type and description for all equipment where the date it was acquired is unknown. Phrasing this more formally, display the data in the assetNo, assetType and description columns for those rows from the Equipment table where the acquired column is NULL.

2. List the asset number, description and cost of all equipment costing £500 or more. List the equipment alphabetically by description. Phrasing this more formally, display the data in the assetNo, description and cost columns for those rows from the Equipment table where the cost is greater than or equal to £500. Order the results alphabetically by description.

3. List the asset number, description and cost of all equipment costing between £500 and £1500, inclusive. Phrasing this more formally, display the data in the assetNo, description and cost columns for those rows from the Equipment table where the cost is greater than or equal to £500 and less than or equal to £1500.