1. The equipment budget for 2005 was £10,000. Display a list of equipment purchased in 2005 showing the asset number, type, description and the percentage of the budget spent on each item. Ensure that...

1. The equipment budget for 2005 was £10,000. Display a list of equipment purchased in 2005 showing the asset number, type, description and the percentage of the budget spent on each item. Ensure that the columns of the result set have suitable names.

2. List the asset number, type and description for all equipment where the description begins with the string ‘HP’. (This should include all equipment manufactured by Hewlett Packard.)