Instructions:Put your SQL in the "Problem 1"


Put your SQL in the "Problem 1" location in the SQL template.

Put your row count in the green box in cell D5.

Create SQL code to display all fields from the students table.  Include only students whose major is Finance (‘FIN’) and who have an in-state residence.  Sort it alphabetically by student first name.

Paste a screen shot of successful execution below.  Be sure your screenshots show all the SQL you use; you are welcome to include several screen shots if necessary.


12-09-20 | 15:56:59

Use university
select * from student
where stdmajor='fin' and
stdresidence='in state'
order by stdfirstname asc;

Login to answer this question!