Consider the following database for projects in a class:

• Student(sid, name, dept)
• Project(pid, topic, budget)
• Team(sid, pid)

Relation Student contains a row for each student with a unique id, student name, and the department of each student. Each row in relation Project holds the unique id of a project, the topic area the students will be working on, and the estimated budget for the project. Finally, the table Team captures the assignments of students to projects.

Which SQL query would retrieve the list of projects with "energy" in the topic and the estimated budget, sorted in descending order based on the budget?

Answer choice:

a	SELECT pid, budget FROM project WHERE topic like '%energy%' ORDER BY budget DESC;
	B	SELECT pid, budget FROM project WHERE topic like %energy% ORDER BY budget DESC;
	C	SELECT pid, budget FROM project ORDER BY budget DESC WHERE topic like %energy% ;
	D	SELECT pid, budget FROM project WHERE topic like '%energy%' ORDER BY budget;