Show the names of all the activities Mark Giuliano participates in.
select t3.activity_name from faculty as t1 join faculty_participates_in as t2 on t1.facid = t2.facid join activity as t3 on t3.actid = t2.actid where t1.fname = "Mark" and t1.lname = "Giuliano"
What rank does Mark Giuliano have?
select rank from faculty where lname = 'Giuliano' and fname = 'Mark'
first name
select fname from faculty order by fname asc